VLOOKUP - Excel 2002 w/sp-1

  • Thread starter Thread starter Russ
  • Start date Start date
R

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
 
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.
 
Back
Top