VLOOKUP, by default, returns a value from the same row in which the
'target' value is found. You don't tell us what you want to return IF
your value is found within the three column range. Do you simply want
to know if the contents of A254 is found within your lookup range?

Also, your given range: Sheet1!$N$4:$O$469 is only two columns wide.

More info, please.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=479919