Forum Discussion
Excel Formula Help
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? ...
This worked. Thanks Detlef.
Regards
Saad
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
Changed formula to:
=LOOKUP(2,1/ISNUMBER(SEARCH(A2,Sheet2!$A$3:$A$42))/(Sheet2!$B$3:$B$42=D2)/(Sheet2!$C$3:$C$42=E2),Sheet2!$D$3:$D$42)
This worked. Thanks Detlef.
Regards
Saad
