Find Date in Array. Return Value to it

[haithman]

Hi,

So Ive got a sheet with 10 columns. 5 Columns with Dates and 5 Columns with $ Values. I am trying to figure a way to look up a day and return the $ value next to the date. Basically I have dates along columns L through N that I want to lookup from the table in columns B through G and return the dollar value next to the date. See attached for a sample file.

[Special-K]

in L4
=IF(ISNA(VLOOKUP(L$3,$B$3:$B$11,1,FALSE)),IF(ISNA(VLOOKUP(L$3,$D$3:$D$11,1,FALSE)),IF(ISNA(VLOOKUP(L$3,$F$3:$F$11,1,FALSE)),"NOT IN TABLES",VLOOKUP(L$3,$F$3:$G$11,2,FALSE)),VLOOKUP(L$3,$D$3:$E$11,2,FALSE)),VLOOKUP(L$3,$B$3:$C$11,2,FALSE))
and copy across to N4

Basically a VLOOKUP for each column (B, D, F). If the VLOOKUP fails, ie ISNA(), look in the next column. If date not found return "NOT IN TABLES" else perform a VLOOKUP and pull the data in the next column

[haithman]

Thanks. But the problem then becomes when i have multiple of the same date in that column. Basically I want to look for the same date in the same row (wherever it may be in that array) and give me the value of the $ one cell to the right of it