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

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

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

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)