Okay, using the ISNA before VLookup works for 2 columns. How do I add a
3rd?
Here is what I have:
=IF(ISNA(VLOOKUP(A254,Sheet1!$N$4:$N$1000,1,FALSE) ),(VLOOKUP(A254,Sheet1!$O$4:$O$1000,1,FALSE)),(VLO OKUP(A254,Sheet1!$N$4:$N$1000,1,FALSE)))
If it is not in column N, look in column O. I need it to look in
Column P if it is not in column N or O.
Sugestions??
--
GorillaBoze
------------------------------------------------------------------------
GorillaBoze's Profile:
http://www.excelforum.com/member.php...fo&userid=5165
View this thread:
http://www.excelforum.com/showthread...hreadid=479919