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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!