CODEWITHSUNDEEP
excelms-officevlookup
omglolgg
omglolgg

Reputation: 135

Excel get data with multiple conditions

I have a table with data like this

enter image description here

How to insert value to C10 base on A10&B10? And C11 base on A11 & B11 too?

Upvotes: 0

Views: 55

Answers (3)

Anoop Kumar
Anoop Kumar

Reputation: 1

Use this formula to get the desired result:

INDIRECT(ADDRESS(MATCH($A$10,$B:$B,0),MATCH($B$10,$2:$2,0)))

Upvotes: 0

Scott Craner
Scott Craner

Reputation: 152595

This is a simple INDEX/MATCH/MATCH:

=INDEX(A:D,MATCH(A10,B:B,0),MATCH(B10,$2:$2,0))

Upvotes: 0

Pyroglyph
Pyroglyph

Reputation: 246

One way is to insert an if function into your vlookup. 

VLOOKUP(A10,B3:D6,IF(B10="x",2,3))

Upvotes: 0

Related Questions