software

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.
Assuming C1 is the value you want to lookup, try this:

=IF(ISERROR(VLOOKUP(C1,$A$1:$B$4,2,FALSE)),.0006,V LOOKUP(C1,$A$1:$B$4,2,FALSE))

HTH,
Elkarquot;jenhowquot; wrote:

gt; I have a range of data like this
gt;
gt; A B
gt; 12 0.014
gt; 13 0.021
gt; 14 0.019
gt; 15 0.022
gt;
gt; I have Vlookup value to return the value from column B if a cell matches
gt; column A. I would like it to return another value (0.006) if the number that
gt; is entered into the cell is not listed in column A.
gt;
gt; I have tried a few different options, but can't seem it get it to work
gt; properly.
gt;
gt; Thanks.
gt;
gt;

One way:

=IF(COUNTIF(A1:A4,C1)lt;1,0.006,VLOOKUP(C1,A1:B4,2))

HTH,
Paul

quot;jenhowquot; gt; wrote in message
...
gt;I have a range of data like this
gt;
gt; A B
gt; 12 0.014
gt; 13 0.021
gt; 14 0.019
gt; 15 0.022
gt;
gt; I have Vlookup value to return the value from column B if a cell matches
gt; column A. I would like it to return another value (0.006) if the number
gt; that
gt; is entered into the cell is not listed in column A.
gt;
gt; I have tried a few different options, but can't seem it get it to work
gt; properly.
gt;
gt; Thanks.
gt;
gt;