LinkBack URL
About LinkBacks
Essentially I need to match ID numbers to pull the owner's name associated with that number. I have an example listed below.
Essentially I need to match ID numbers to pull the owner's name associated with that number. I have an example listed below.
A basic VLOOKUP will do:
=VLOOKUP(C2,$G$2:$H$7,2,0)
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.
I have been trying that in my actual sheet and continue to receive an N/A error. Would you have any ideas why that is?
You have no matches - simple as.
Check that numbers are numbers and that you are not trying to compare a number with text, same with dates, check for leading and trailing spaces.
Or you have the array and criteria wrong in the VLOOKUP.
Beyond this, without seeing the data, no idea.
By the way, there really wasn't any need to start this new thread - next time, keep questions on what are essentially the same issue in the same place.
Last edited by AliGW; 07-13-2021 at 10:49 AM.
In A2 =INDEX($H$2:$H$7,MATCH(C2,$G$2:$G$7,0)) and then copy down.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks