You can only get one return using a VLOOKUP. But, you can get tricky and
use CONCATENATION to create a new lookup column and then look up
CONCATENATED combinations...........
something like...........
=VLOOKUP(A1&B1,D:E,2,FALSE)
where column D has the CONCATENATED value combinations you're looking
for............
Vaya con Dios,
Chuck, CABGx3
"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.
|