Lookup within Vlookup - Search more than one cell and use vectors instead of array

sapientsaphead

New Member
Joined
Dec 29, 2008
Messages
4
Hello there!
I have the following sample setup:

Excel | Flickr - Photo Sharing!

(sorry I tried attaching an image several times and it didn't work)

I am trying to find words from column E in either cell A2 or cell B2 (preferably it would search A2 and if it didn't find anything would then search B2), and input the corresponding word in column F as the Product Type. I am encountering two problems:
1. I can't figure out how to tell it to search within both A2 or B2 or better yet, search A2 and if no results then search B2 as an alternative
2. I can't figure out how to do column E and column F vs. E1:E9 and F1:F9

Here's what I have so far:
=VLOOKUP(LOOKUP(2,1/SEARCH($E$1:$E$9,A2),$E$1:$E$9),E:F,2, FALSE)

Any help would be greatly appreciated.
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Watch MrExcel Video

Forum statistics

Threads
1,095,358
Messages
5,444,001
Members
405,259
Latest member
charliechaz

This Week's Hot Topics

Top