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
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.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
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.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks