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
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Janis" wrote in message
...
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,

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" wrote:

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,

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

"Elkar" wrote:

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" wrote:

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,

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

"Janis" wrote:

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

"Elkar" wrote:

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" wrote:

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,

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



--
Regards,

Peo Sjoblom



"Janis" wrote in message
...
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,