VLOOKUP returning #INVALID REF

I am receiving the #INVALID REF error in smartsheet and I am not sure how to correct it.

=VLOOKUP([PART NUMBER]1, [PN]1:[PART DESCRIPTION]1800, {2,3,4,5}, false)

Below is the excel sheet formula that does work but does not flow over to the smartsheet.

=VLOOKUP($Q6,$A4:$D25014,{2,3,4,5},FALSE)

If you look at the excel spreadsheet screen shot below, what I want is a formula entered into the PART NUMBER column where if you enter a number from the PN column into the COLUMN A column it will return the value of the OTHER PN column.

I hope that makes some sense, any help is always very much appreciated. Thank you!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!