But if your data looks like:
aaa bbbb
aaab bbb
a aabbbb
It could yield the incorrect results.
=INDEX(range,MATCH(A1&char(10)&B1,AA1:AA10&char(10 )&AB1:AB10,0))
(using alt-enter as a separator--if it's not used within the strings.)
Biff wrote:
OR, you could combine elements of both Chuck's and Dave's examples and does
not need a concatenated helper column.
=INDEX(range,MATCH(A1&B1,AA1:AA10&AB1:AB10,0))
Entered as an array with the key combo of CTRL,SHIFT,ENTER.
Biff
"puppy" wrote in message
...
I know how to use vlookup() but I have found a new problem.
Say I have a BIG sheet and want to search it for MORE THAN ONE match in
multiple columns.
Further explination:
I do a vlookup() of the table, but there are multiple matches with the
first
paramater.
So a second paramater is given and so from the first match, I want a
second
match made.
Is this possible?
thanks much in advance.
--
Dave Peterson
|