Anonymous
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
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
Participate on our website and join the conversation
You have already an account on our website? Use the link below to login.
Login
Create a new user account. Registration is free and takes only a few seconds.
Register
This topic is archived. New comments cannot be posted and votes cannot be cast.
Responses to this topic
Tuckwit
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
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
OP
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
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
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)
Ich speche kien deutsche (or something like that)