Forum Discussion
Solved
IF and THEN formula help
I searched through some posts but I could not find what I needed... I have a spreadsheet with 2 tabs. I need it to search column A on Tab1 with column C on Tab2 IF they match then I need it to pu...
If multiple matches exist, this formula returns the last:
=IFNA(LOOKUP(2,1/(
Sheet2!C:C=A2),
Sheet2!B:B),"")
Please give this a try...
On Sheet1,
In C2
=IFERROR(INDEX(Sheet2!B:B,MATCH(A2,Sheet2!C:C,0)),"")
And then copy it down.