Forum Discussion

saad soliman's avatar
saad soliman
Copper Contributor
Jul 07, 2018
Solved

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?   ...
Formulas & Functions
Need Help
  • saad soliman's avatar
    saad soliman
    Jul 08, 2018

    This worked. Thanks Detlef.

     

    Regards

    Saad

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jul 08, 2018

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)

 

saad soliman's avatar
saad soliman
Copper Contributor
Jul 08, 2018

This worked. Thanks Detlef.

 

Regards

Saad

Resources