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),"")
laceypearl perhaps you forgot to make absolute the reference, look at this short video,https://www.youtube.com/watch?v=SVPlRHK-XbI I hope it helps..