Dynamically Lookup values based on 2 conditions and then a range between (specified in 2 columns)

[murtuzamalak]

Hi,

I am stuck with an excel issue, where I need to look values based on

 

[amiroo]

Hi,
create a column in your db after column D with this formula:
= B2&C2
and then drag it down

and then in your performance type sheet you can use this formula for needed data:

= VLOOKUP(A3&B3,db!$E:$H, 2,0)

db is your DB sheet name

 

[murtuzamalak]

Hi,
I guess I did not explain it in a better way. It also has to look at a logical condition. Posting Images again.

 

[amiroo]

I got it.
use this formula in array mode for performance type column:

=INDEX(db!E:E,MAX(ROW(db!E:E)*(db!B:B=A3)*(db!C:C<=B3)*(db!D:D>=B3)))

 

[murtuzamalak]

Thanks Sir, It actually worked with the Index & Match combination in Array type