CODEWITHSUNDEEP
excelexcel-formula
TiesA
TiesA

Reputation: 15

Excel: returning value in range based on 2 criteria

I'm trying to work out the following.

I have the following columns:

See image of worksheet

What I am trying to do is to create a formula that will return the correct profit based on 2 values:

So, let's say cell A3 = "M3", cell A4 = "Hatchback". How do I create a formula that will return the value in cell F4, 16%?

What seems to break my lookup formulas is the fact that I have multiple identical values (Sedan, Hatchback).

Thank you in advance!

Upvotes: 0

Views: 85

Answers (1)

JvdV
JvdV

Reputation: 75840

One possibility:

=INDEX(INDEX(C3:H4,0,MATCH(A3,C2:H2,0)+1),MATCH(A4,INDEX(C3:H4,0,MATCH(A3,C2:H2,0)),0))

Upvotes: 1

Related Questions