Need help with a Vlook-up/If Statement

[DMcVey]

Hello,

I am looking for some expertise in my attached worksheet.

I need consistent formulas to apply the query rules from table on Row 18 for Performance rating 4,3,2. I need to have these rules applied with formulas in Min, Default, Max (Columns E, F & G)

And I need the value in Column H from lookup table Column Q.

All the answers are highlighted in green. I just need the formulas to pull from the appropriate tables.

Let me know if you have any further questions.

Thanks,

DMcVey

[FDibbins]

See if this will work for you...
=INDEX($Q$3:$Q$26,MATCH($B3&$D3,INDEX($J$3:$J$26&$L$3:$L$26,,),0))
copied down

Adjust the bolded range for the other columns you need.

[kvsrinivasamurthy]

Pl see file.
Not to display value in column F
Select F2:F15 --> format cells --> Custom --> ;;;
In F2 then copied across.

Please Login or Register  to view this content.