View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Janis Janis is offline
external usenet poster
 
Posts: 360
Default vlookup almost works but not quite

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,