vlookup almost works but not quite

J

Janis

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,
 
D

Don Guillett

And your definition of "doesn't work?" is?
If you look in the help index for VLOOKUP you will find out what ,false
means
 
E

Elkar

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
 
P

Peo Sjoblom

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
 
J

Janis

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...
 
J

Janis

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...
 
Top