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,