Please help me troubleshoot this vlookup formula cross referencing another sheet

kmccoy1

Hi,

Please help me identify the error in this formula:

=VLOOKUP(Barcode@row, {Main List!Barcode:Item Name}, 2, false)

I'm trying to use the formula in a sheet called "Equipment Tracker" to pull in the Item Name column using the Barcode to reference the correct Item Name in another sheet called "Main List".

In both sheets, the column Barcode is the Primary column and Item Name is column B.

Thanks!

KPH

That makes sense. The problem will be one of the references. Probably the cross sheet reference. Highlight the part in bold:

=VLOOKUP(Barcode@row, {Main List!Barcode:Item Name}, 2, false)

Delete it.

Then leaving the cursor where it was, create a new reference.
You need to select the two columns you show above and give the range a name (I would avoid ! And : in the name. Save that reference.
The formula will update to show your new reference in place of the part in bold.

That could be all that is needed.

Good luck!

This page explains criss sheet formula
https://help.smartsheet.com/learning-track/level-3-advanced-users/cross-sheet-formulas

KPH

Hi @kmccoy1

Your formula looks good. Can you tell me what the error is?

kmccoy1

Hello,

I keep getting this error: #INVALID REF

KPH

That makes sense. The problem will be one of the references. Probably the cross sheet reference. Highlight the part in bold:

=VLOOKUP(Barcode@row, {Main List!Barcode:Item Name}, 2, false)

Delete it.

Then leaving the cursor where it was, create a new reference.
You need to select the two columns you show above and give the range a name (I would avoid ! And : in the name. Save that reference.
The formula will update to show your new reference in place of the part in bold.

That could be all that is needed.

Good luck!

This page explains criss sheet formula
https://help.smartsheet.com/learning-track/level-3-advanced-users/cross-sheet-formulas

kmccoy1

THANK YOU! This fixed it and I learned something :)

I appreciate your help!

KPH

Wonderful. Thanks for letting me know.