Vlookup Failing

MelissaSan

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.

Melissa Yamada

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.

https://help.smartsheet.com/function/index