Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In Excel I need to do a lookup function that derives its results from the
intersection of a row and Column for a grade equivalent. It is a combined math test score that takes the Score from the math computation section as it is displayed horizontally across the top of the table and then checks against the score from the applied mathematics section that is displayed vertically down a column. The intersection of that row and column give a grade equivalent. How can I make the lookup check both horizontal and vertical sections and return a score? Any information will be appreciated Thanks tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |