Hi,
What formula I could use to search an exact match of three cells in the first worksheet from the second worksheet and retrieve a specific value from the last column in the second worksheet?
Attached is a sample data sheet.
Thanks
This worked. Thanks Detlef.
Regards
Saad
Saad,
=LOOKUP(2,ROW(Sheet2!$D$2:$D$3)/(Sheet2!$A$2:$A$3=A2)/(Sheet2!$B$2:$B$3=B2)/(Sheet2!$C$2:$C$3=C2),Sheet2!$D$2:$D$3)
Hi Detlef,
I have tried this formula, but the problem is that I have to know which row number I should look for in Sheet2, which is Row # 2 in the formula you sent. I need a generic formula.
Thanks
I have attached another Sheet with more data. I need to retrieve the Hourly rate in Column H (Sheet1) for the exact match of "Position", "Work Type" and "Age" in Sheet2.
Regards
