Bonjour,
I have two large spreadsheets. I want to match the values in 4 cells (within
the same row) in one spreadsheet and search a second spreadsheet to match the
values in 4 cells (within the same row). If the 4 cells between the two
spreadsheets match, I want to return a text from the second spreadsheet (from
the row in which all 4 values match) to a cell in the first spreadsheet.
First spreadsheet
G I J O
1 Price Start Date End Date Product
2 2.62 06/08/08 06/14/08 6410036254
3 2.62 06/12/08 06/14/08 6410036260
4 25.00 06/08/08 06/13/08 6410000046

Here is my formula. It works but only with specified cell (for example
'rpt_Custom 1 '!O60, this is only 1 cell but i want to apply it to the whole
spreadsheet).
=VLOOKUP($O4,'rpt_Custom 1 '!C60:P60,IF(AND(I4='rpt_Custom 1
'!O60,J4<='rpt_Custom 1 '!P60,G4='rpt_Custom 1 '!N60),2,FALSE),FALSE)
--
Nancy