VLookup help

AliT

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.

Yvonne Smythe

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

1. source sheet:

2. Vlookup sheet:

Yvonne Smythe

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

1. source sheet:

2. Vlookup sheet:

AliT

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.

AliT

I figured it out!! I was not choosing the entire table, but only a column!!

Yvonne Smythe

https://community.smartsheet.com/discussion/comment/463602#Comment_463602