# Returning a value based on two conditions

1. ## Returning a value based on two conditions

Hi all,

I am trying to return values based on two criteria. I imagine I'm looking for something similar to a VLOOKUP, but I need it to match an additional cell.

In the attached spreadsheet I'm looking for a formula to fill H3:H11 by finding corresponding values in Q3:Q17.

2. ## Re: Returning a value based on two conditions

Try this formula in H3 and copy it down

=INDEX(\$Q\$3:\$Q\$17,INDEX(MATCH(A3&B3,\$O\$3:\$O\$17&\$P\$3:\$P\$17),0),0)

3. ## Re: Returning a value based on two conditions

I'm not following. What are the two conditions? What should the results be? This will help to understand what you are looking for.

4. ## Re: Returning a value based on two conditions

Originally Posted by AlKey
Try this formula in H3 and copy it down

=INDEX(\$Q\$3:\$Q\$17,INDEX(MATCH(A3&B3,\$O\$3:\$O\$17&\$P\$3:\$P\$17),0),0)
Thanks! This looked like it worked.

5. ## Re: Returning a value based on two conditions

You're welcome and thank you for the feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1