VLookup

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.
Answers
-
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?
-
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.
-
Which number comes in when you scan the barcode? Is it the Serial Number or something else?
-
its the "Tag" number
-
It looks like the search value is the same as the tag number? Sorry. I'm just confused on what the end goal is.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.7K Get Help
- 474 Global Discussions
- 201 Use Cases
- 515 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!