Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a gridchart that uses horizontal numbers and vertical numbers. The
outside numbers are two sections of an exam. The internal numbers are the final score. Example below 1 2 3 4 5 55 62 63 64 65 66 56 64 66 68 70 72 57 66 68 70 72 74 58 68 70 72 74 76 I want to enter 2 numbers (shown on outside of grid)- lets say a 55 and a 4 for a particular student. What I want excel to do is enter the final score in a specified cell using the data on the grid I entered. So if I enter a 55 and a 4 for a student- Excel will put the final score of a 65 in the cell for that student. I beleive it is a vLookup function, but cannot figure it out. Please help me!! Thanks for any advice |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |