View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jenhow
 
Posts: n/a
Default Vlookup - no match

I have a range of data like this

A B
12 0.014
13 0.021
14 0.019
15 0.022

I have Vlookup value to return the value from column B if a cell matches
column A. I would like it to return another value (0.006) if the number that
is entered into the cell is not listed in column A.

I have tried a few different options, but can't seem it get it to work
properly.

Thanks.