vlookup almost works but not quite

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Do you know why my vlookup doesn't work?

=VLOOKUP(B14,[VOD_v2.4a.xls]VOD!$H:$AL,27,FALSE)

In column B starting with cell 14, I have a service group field. I want to
match it with the service group field in column H on the VOD sheet. The
value I want to print is column AL which is 27 columns from H. I always put
false at the end. I don't know what that is for.

tia,
 
And your definition of "doesn't work?" is?
If you look in the help index for VLOOKUP you will find out what ,false
means
 
Column AL would actually be 31 columns from H, not 27. Is that where the
problem is?

The FALSE portion of the VLOOKUP function tells Excel that it needs to find
an Exact match as opposed to an approximate match (next largest value).

HTH,
Elkar
 
AL is not 27 columns from H, it's 31

Instead of counting using the eye and the mouse or whatever you are using
which is error prone you can simply use

=COLUMNS(H:AL)

will give you the number
 
Oh, I see the count starts from A instead of from the match key?
thanks,

Elkar said:
Column AL would actually be 31 columns from H, not 27. Is that where the
problem is?

The FALSE portion of the VLOOKUP function tells Excel that it needs to find
an Exact match as opposed to an approximate match (next largest value).

HTH,
Elkar


Janis said:
Do you know why my vlookup doesn't work?

=VLOOKUP(B14,[VOD_v2.4a.xls]VOD!$H:$AL,27,FALSE)

In column B starting with cell 14, I have a service group field. I want to
match it with the service group field in column H on the VOD sheet. The
value I want to print is column AL which is 27 columns from H. I always put
false at the end. I don't know what that is for.

tia,
Click to expand...
Click to expand...
 
Oh, well I guess I just mis counted. It is 31 from H:AL. Thanks again for
the columns array function.

Janis said:
Oh, I see the count starts from A instead of from the match key?
thanks,

Elkar said:
Column AL would actually be 31 columns from H, not 27. Is that where the
problem is?

The FALSE portion of the VLOOKUP function tells Excel that it needs to find
an Exact match as opposed to an approximate match (next largest value).

HTH,
Elkar


Janis said:
Do you know why my vlookup doesn't work?

=VLOOKUP(B14,[VOD_v2.4a.xls]VOD!$H:$AL,27,FALSE)

In column B starting with cell 14, I have a service group field. I want to
match it with the service group field in column H on the VOD sheet. The
value I want to print is column AL which is 27 columns from H. I always put
false at the end. I don't know what that is for.

tia,
Click to expand...
Click to expand...
Click to expand...
 
Back
Top