Lookup formula problem

[toan]

How can I make my lookup formula return a zero or blank if it can't find my reference in the lookup range. Right now, it's returning the last value in the lookup range when it can't find a the reference.

Any help would be greatly appreciated.
Thanks in advance.

Toan

 

[Aladin Akyurek]

On 2002-10-21 12:19, toan wrote:
How can I make my lookup formula return a zero or blank if it can't find my reference in the lookup range. Right now, it's returning the last value in the lookup range when it can't find a the reference.

Any help would be greatly appreciated.
Thanks in advance.

Toan

Try to use VLOOKUP instead of LOOKUP... See my contrib in

http://216.92.17.166/board/viewtopic.php?topic=26029&forum=2&3

 

[Mark W.]

On 2002-10-21 12:19, toan wrote:
How can I make my lookup formula return a zero or blank if it can't find my reference in the lookup range. Right now, it's returning the last value in the lookup range when it can't find a the reference.

Any help would be greatly appreciated.
Thanks in advance.

Toan

Either add these missing values to your table or use an IF function to test your lookup_value.