I like this syntax:
=index(othersheet!$c$1:$c$10,
match(1,(a2=othersheet!$a$1:$a$100)*(b2=othersheet !$b$1:$b$100),0))
puppy wrote:
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
|