VLOOKUP - Excel 2002 w/sp-1

[Russ]

I have 2 problems. In doing a VLOOKUP in a table, if the
lookup_value is not exact, the function is returning the
next lower value (ie - looking for 4118-03 and it is
returning information for 4118-02 because there is no 4118-
03). How do I get the function to return nothing or "0"
if the lookup_value is not in the table?
The second problem is with multiple lookup_values in the
same table. (ie - If I have more than one 4118-03, can I
get the function to return one set of information in 1 row
and the next set of information in the next row?
Anyone have any ideas?
Thanks
Russ

 

[Andy B]

Hi

You need to set the last item in the VLOOKUP formula to false - then it will
only return an exact match.

From Help:
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

If VLOOKUP can't find lookup_value, and range_lookup is FALSE, VLOOKUP
returns the #N/A value.

Hope this helps.