Forum Discussion
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 put the name from column B on Tab2 into column C on Tab1.
I tried the lookup formula and it worked for the first space, but then when i copied the formula down the column it put in names that were not correct.
Thank you!
If multiple matches exist, this formula returns the last:
=IFNA(LOOKUP(2,1/(
Sheet2!C:C=A2),
Sheet2!B:B),"")
5 Replies
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!
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.
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..
