GorillaBoze Wrote:
Is it possible for a VLookup to look in 3 columns instead of 1?
For example: =VLOOKUP(A254,Sheet1!$N$4:$O$469,*1:3*,FALSE)

There is only data in one of the three columns in each row. Maybe
something else will work better??

As an addendum, if we assume you want to look in N and O for your value
and return from P if found, try this:

=IF(ISNA(A254,Sheet1!$N$4:$P$469,3,0)),VLOOKUP(A25 4,Sheet1!$O$4:$P$469,2,0),VLOOKUP(A254,Sheet1!$N$4 :$P$469,3,0))

If your value is not in N (returns #N/A), it will look in O. If found
in N it will return the value in P. If found in O, it returns value in
P. If not found at all, returns #N/A.

Hope this works for you.


--
swatsp0p


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