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),"")
Twifoo this one worked, THANK YOU!
I’m glad it did. You’re welcome!