need Help with EXEL

hiho, I am searching for a formula. . . but can't find it. . . . followin: I have a database with for example 5xX and 4xY values. . . . so a 5x4 table not the first line is a Date e.

Warp2search Hang Out

This topic was started by 24518f9903e3c3d5891f4cc2012e80afdb9f50e8, 2004-01-11 19:32

Discussion 3

Anonymous

0 Posts
Location -
Joined -

#23188

2004-01-11 19:32

hiho,

I am searching for a formula ... but can't find it .... followin:

I have a database with for example 5xX and 4xY values .... so a 5x4 table
not the first line is a Date e.g. 1x1 = 01.01.2004 ... 1x2 = 02.01.2004 and so on
on line 2, 3 and 4 are spezific values recorded for that date
now I want to have a formula whicht selects the right value which fits to the date ..... for example I enter the date 02.01.2004 then it should paste the value from field 2x2

anyone know hat to do ??? I have searched through the various formulas but I haven't found the right one or I did something wrong ...

best regards

Sound Blaster Pin Layout

XP Task Manager - CPU%

Participate on our website and join the conversation

You have already an account on our website? Use the link below to login.

Create a new user account. Registration is free and takes only a few seconds.

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic

Tuckwit

62 Posts
Location -
Joined 2002-09-26

#23189

2004-01-22 21:55

And in return,

Say the cells are from A1 to B3

A1=01/01/2004, B1=02/01/04
A2=1, B2=2
A3=3, B3=4

Try =HLOOKUP(DATE(2004,1,2),A1:B3,3))

Would return 3

Have fun

Anonymous

0 Posts
Location -
Joined -

#23190

2004-01-22 22:56

already found a formula .... just used the "normal" SUMMEWENN / SUMMIF
not that I SUMM something up but 0+ only the value gives only the value ...
and that what I want ..
also its quite easy to make
now its ...

=SUMMEWENN(5:5;C33;8:8 )

5:5 = dates
C33 = searched date
and the it takes the right field from line 8

Tuckwit

62 Posts
Location -
Joined 2002-09-26

#23191

2004-01-22 22:57

I gave the wrong first answer (should be Hlookup in english), then w2s crashed, have edited it, sorry about that.

Ich speche kien deutsche (or something like that)