LinkBack URL
About LinkBacks
If A2 is equal to any rows in Sheet 2 column A, then return the value of Sheet 2 Column 2, else return the value of Sheet 1 Column D.
Coloured boxes are the places where I need to populate data from Sheet 2
If A2 is equal to any rows in Sheet 2 column A, then return the value of Sheet 2 Column 2, else return the value of Sheet 1 Column D.
Coloured boxes are the places where I need to populate data from Sheet 2
I think you are getting sheet names wrong.. Can you recheck the attachment?
Cheers!
Deep Dave
I think your references don't match your post. But is this what you want? =IFERROR(VLOOKUP(B3,Sheet2!A:B,2,FALSE),Sheet1!C3)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you so much! This is exactly what I needed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks