Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup help
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup help
Assumptions:
Math computation score in A2, applied math in A3, table in B1:Z100 (with labels in row 1, column b) =INDEX(C2:Z100,MATCH(A3,B2:B100),MATCH(A3,C1:Z1)) Index allows exactly what you asked, an intersection of row number with column number. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tom" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup help
stop multi posting, you have answers in your other post
"Tom" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |