LinkBack URL
About LinkBacks
sheet 1.png
sheet 3.png
Sheet 1 and sheet 3 pics above, hope that helps.
The row on sheet 3 with 198 and the numbers and name are how I want it to look if possible.
sheet 1.png
sheet 3.png
Sheet 1 and sheet 3 pics above, hope that helps.
The row on sheet 3 with 198 and the numbers and name are how I want it to look if possible.
Yes, you can! Have a look here:Now, here's the bad news. You can't use VLOOKUP to return something to the left (Col A in this case) of what you are looking up (Col B).
http://www.excelforum.com/excel-tips...d-vlookup.html
INDEX MATCH is easier, though.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks