VLookup

Stephanie Taylor

Hi,

Formulas are not my stong point.

I am looking for a formula that when a number is scanned into column named "Result" it will look for that number in a column labeled "Tag Number".

Any help is appreciated.

Paul Newcome

Are both columns on the same sheet? What is the final outcome expected? Are you able to provide a screenshot for context as well as more details as to how the sheet is operating?

Stephanie Taylor

I would like to scan a barcode into column "Scanned Barcode" and would like to find the number in column "Search Value" and place the number in column "Result" on the same row as the number in the "Search Value" column.

Paul Newcome

Which number comes in when you scan the barcode? Is it the Serial Number or something else?

Stephanie Taylor

its the "Tag" number

Paul Newcome

It looks like the search value is the same as the tag number? Sorry. I'm just confused on what the end goal is.