Vlookup - Reference another Sheet

Ozu

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.

Stacy Meadows

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

https://community.smartsheet.com/discussion/comment/353688#Comment_353688

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

Stacy Meadows

Can you take a snip of the range you are looking up ? I believe this is the issue... and I will try assist x

Stacy Meadows

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? :)

Ozu

@Stacy Meadows

I am selecting the whole table, but feel like it's not picking the whole table. When I type true as match type, the value started appearing but with false nothing shows up.

Stacy Meadows

Alternatively you may have the right range...

Is the Company names capitalised on both sheets ??? sometimes the letter casing can effect formulas ?? :)

Stacy Meadows

https://community.smartsheet.com/discussion/comment/353688#Comment_353688

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

Ozu

@Stacy Meadows Thanks, getting my answers correct :)