Vlookup - Reference another Sheet

Options
Ozu
Ozu ✭✭
edited 12/08/22 in Formulas and Functions

I have entered Vlookup but getting #NoMatch error. Feels like something is not right in my formula. Can anyone please help?

When I type true as match type, the value started appearing but with false nothing shows up.

Best Answers

  • Stacy Meadows
    Stacy Meadows ✭✭✭
    Answer ✓
    Options

    Check the starting column of your range is equivalent column to customer name on the other sheet and you count the columns from there...

    Example I want to take the Date from sheet 1 to sheet 2 if my DEP code matches so:

    =vlookup(Depcode@row, {Sheet a /1 Range 4}, 2,false)

    As you can see, I started at the DEP column as this is equivalent to my Depcode@row on sheet 2, I then chose column 2 as you count the columns starting with 1 first column highlighted.

    Hope this helps ...

    If not put a snapshot of your other sheet if possible? :)

  • Stacy Meadows
    Stacy Meadows ✭✭✭
    Answer ✓
    Options

    Ok so do not select the whole table start at Customers columnand select from there.... so then your column number needs to be 10 :)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!