Vlookup Failing

Hi,
I am trying to lookup a value in Table B and populate a row in "Table A
I am matching on "DeviceName" in Table A to "Computer Name" in Table B
And then want to populate UpdateWin11 Success with the value in Table B "Service Pack"
Table A - this is where i am writing the VLOOKUP in the Update WIN11 Success column
Table B
But each time i run it is is coming back with #Unmatched and I know the values are there.
Answers
-
Hello @MelissaSan
The reason of the #Unmatched error is your device name does not match with your computer name. Make sure they match exactly if not you may need to have your device name on table b or computer name on table a.
Also, can you share your formula?
You can also explore INDEX/MATCH or INDEX/COLLECT functions.
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!