VLookup help

AliT
AliT ✭✭
in Formulas and Functions

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.

image.png

· Share on FacebookShare on Twitter

Best Answer

  • Yvonne Smythe
    Yvonne Smythe ✭✭✭✭✭✭
    edited 11/25/24 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

    1. source sheet:
    image.jpg

    2. Vlookup sheet:

    image.jpg

    Best Regards,

    Yvonne Smythe

    · Share on FacebookShare on Twitter

Answers

  • Yvonne Smythe
    Yvonne Smythe ✭✭✭✭✭✭
    edited 11/25/24 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

    1. source sheet:
    image.jpg

    2. Vlookup sheet:

    image.jpg

    Best Regards,

    Yvonne Smythe

    · Share on FacebookShare on Twitter
  • AliT
    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.

    · Share on FacebookShare on Twitter
  • AliT
    AliT ✭✭

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

    · Share on FacebookShare on Twitter
  • Yvonne Smythe
    Yvonne Smythe ✭✭✭✭✭✭
    https://community.smartsheet.com/discussion/comment/463602#Comment_463602
    IMG_1342.jpeg

    Best Regards,

    Yvonne Smythe

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!