vlookup almost works but not quite

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

 

[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

 

[Guest]

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

 

[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

 

[Guest]

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

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

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,

 

[Guest]

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

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

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

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,