Is it possible to do a vertical lookup that matches on 2 criteria

  • Thread starter Thread starter Guest
  • Start date Start date
Post a proper quaetion in the body of the message, your subject line gets
truncated

Regards,

Peo Sjoblom
 
I agree with Peo, but as a tip: you can drag the border dividing the posts
and the current one to see all the subject.

Regarding your question, you cannot do it with the VLookup. The thing is
that the solution depends on your needs. What would happen if more than two
values meet the criteria?

Exactly what do you want to do here?

G.Morales
 
Thanks for the tip!
I am trying to search a table and match both on a client and date. I am
fine if it just picks up the first combination because I have already
summarized the data on that combination.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup returning wrong results 0
Vlookup & 2 variables 3
Index Match on Columns and Rows 0
lookup 6
lookup second / last match with two conditions 1
MATCH Function - 2 Dimension Arrays 3
With F1 value, look at A, if match or partial match return B 5
how do you have 2 criterias be picked up in a lookup? 5

Back
Top