View Single Post
  #1   Report Post  
puppy
 
Posts: n/a
Default is there a way to search with vlookup to match more than 1 column

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.