Hi all,

I am using the following lookup statement -

=VLOOKUP($B11,Distribution!$B$12:$B$150,1,FALSE)

If the value does not exist, excel returns #N/A, which is to be
expected. However, I would like it to return a different value if the
VLOOKUP value does not exist.

ie. instead of #N/A I would like it to return a text string of my
choice.

I have tried to use an IF statement...eg

=IF((VLOOKUP($B11,Distribution!$B$12:$B$150,1,FALS E)=B11, B11, "Text
string")

However, this still returns an N/A when the value does not exist.

Can anyone suggest a way around this? I get the feeling I may be
missing something very simple :P


Cheers

Rob


--
systemx
------------------------------------------------------------------------
systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254
View this thread: http://www.excelforum.com/showthread...hreadid=523442