VLookup help
HI.
I need to look up a # based on the entry entered in one column. I have established a look up table, but having a difficult time with the formula.
example - I enter ACME Supplies and I want it to look up the vendor number in the table and return the value into the corresponding field.
Best Answer
-
Hi @AliT - Here you go. Hope this helps.
=VLOOKUP([Column2]@row, {VLookup Test Range 1}, 2, false)
I also use the links below as my go to resources:
• https://help.smartsheet.com/functions?_gl=116q0zhr_gcl_auMTE0MjM1MDE4Ni4xNzMxODg2Mjc0LjEzMDUyMzk3NjEuMTczMjA4OTEwMC4xNzMyMDg5MTAw_gaNzEyNTEwMzEyLjE3MzE3NzU0ODM._ga_ZYH7XNXMZK*MTczMjU1OTkyNi44MS4xLjE3MzI1NjE2NjIuNTQuMC4w• https://app.smartsheet.com/b/publish?EQBCT=32f8257f5d1948bfa948da170231a0c5&_gl=1174b4ob_gcl_auMTE0MjM1MDE4Ni4xNzMxODg2Mjc0LjEzMDUyMzk3NjEuMTczMjA4OTEwMC4xNzMyMDg5MTAw_gaNzEyNTEwMzEyLjE3MzE3NzU0ODM._ga_ZYH7XNXMZK*MTczMjU1OTkyNi44MS4xLjE3MzI1NjM0MjEuMTIuMC4w
- source sheet:
2. Vlookup sheet:
Best Regards,
Yvonne Smythe
Answers
-
Hi @AliT - Here you go. Hope this helps.
=VLOOKUP([Column2]@row, {VLookup Test Range 1}, 2, false)
I also use the links below as my go to resources:
• https://help.smartsheet.com/functions?_gl=116q0zhr_gcl_auMTE0MjM1MDE4Ni4xNzMxODg2Mjc0LjEzMDUyMzk3NjEuMTczMjA4OTEwMC4xNzMyMDg5MTAw_gaNzEyNTEwMzEyLjE3MzE3NzU0ODM._ga_ZYH7XNXMZK*MTczMjU1OTkyNi44MS4xLjE3MzI1NjE2NjIuNTQuMC4w• https://app.smartsheet.com/b/publish?EQBCT=32f8257f5d1948bfa948da170231a0c5&_gl=1174b4ob_gcl_auMTE0MjM1MDE4Ni4xNzMxODg2Mjc0LjEzMDUyMzk3NjEuMTczMjA4OTEwMC4xNzMyMDg5MTAw_gaNzEyNTEwMzEyLjE3MzE3NzU0ODM._ga_ZYH7XNXMZK*MTczMjU1OTkyNi44MS4xLjE3MzI1NjM0MjEuMTIuMC4w
- source sheet:
2. Vlookup sheet:
Best Regards,
Yvonne Smythe
-
Apologies for not replying as I had left early from work. I am still a bit confused on the formula and I couldn't get it to work. My lookup table is named Vendor and I have two columns on that sheet. Column 1 is Vendor and Column 2 is the EPOS vendor #. On my Purchase order sheet where I enter all of the PO's, is where I want the EPOS vendor number to autofill when I type in a vendor name. I have an entire list of Vendors and their corresponding numbers, so the formula needs to look at the whole column.
-
I figured it out!! I was not choosing the entire table, but only a column!!
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!