Vlookup

[Guest]

I also am trying to do a seemingly simple vlookup. I am comparing a value in the 1st column of a worksheet to find its match in a second worksheet and return a value in the 3rd column of the second worksheet. I get no results at all.

My formula is: vlookup(C2,LIST, 3, FALSE

C2 is a cell reference in the first worksheet holding a value I want searched in the second worksheet.
The name of the second worksheet is List. Where I want to return a value located in the third column
If an exact comparison value is not found I want a return of NA. Therefore, I entered false

I am getting no results. What am I not doing? Help!!

 

[Guest]

Your formula will work if you simply go to your LIST worksheet, select the data you are using as the search area (like maybe columns A through C), and hit Insert-Name-Define and call it ... LIST

To do the same WITHOUT naming your range, here's the formula you'd need

vlookup(C2, LIST!$A:$C, 3, FALSE

Note the syntax of using a worksheet reference compared to the syntax of a named range. That's why I like named ranges in my vlookups. They're much easier to type the formulas, and can generally be a lot shorter and no dollar signs required

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*-
Hope this helps
Anne Tro
Author: Dreamboat on Wor
Email: Dreamboat*at*Piersontech.co
Web: www.TheOfficeExperts.co

 

[Paulw2k]

Hi Regina

The function looks at a specific range of cells not the whole worksheet, so
the second element should read LIST!$A:$C.
Alternatively, you could just name the data block you are referencing and
use that name instead.

Regards
Paul

I also am trying to do a seemingly simple vlookup. I am comparing a value

in the 1st column of a worksheet to find its match in a second worksheet and
return a value in the 3rd column of the second worksheet. I get no results
at all.

My formula is: vlookup(C2,LIST, 3, FALSE)

C2 is a cell reference in the first worksheet holding a value I want

searched in the second worksheet.