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.
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.
