| XLookup_Example_XelPlus.xlsx | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 1 | serial# | Student Name | Student ID No. | Assignment 1 | Assignment 2 | Assignment 3 | Midterm Exam | Final Exam | ||
| 2 | 1 | Wilson, Wade | 4438 | #N/A | ||||||
| 3 | 2 | Warren, Miles | 9701 | |||||||
| 4 | 3 | Rogers, Steve | 8187 | |||||||
| 5 | 4 | Richards, Franklin | 9605 | |||||||
| 6 | 5 | Rasputin, Piotr | 6795 | |||||||
| 7 | 6 | Pym, Henry | 2323 | |||||||
| 8 | 7 | Olsen, Jake | 4898 | |||||||
| 9 | 8 | Myers, Fred | 7650 | |||||||
| 10 | 9 | Marko, Flint | 8834 | |||||||
| 11 | 10 | Marko, Cain | 9912 | |||||||
| 12 | 11 | Macendale, Jason Phillips | 8423 | |||||||
| 13 | 12 | Kingsley, Roderick | 1682 | |||||||
| 14 | 13 | Kasady, Cletus | 8998 | |||||||
| 15 | 14 | Jones, Angelica | 3923 | |||||||
| 16 | 15 | Hardy, Felicia | 9474 | |||||||
| 17 | 16 | Foswell, Frederic | 2180 | |||||||
| 18 | 17 | Essex, Nathanial | 9680 | |||||||
| 19 | 18 | Esks, Basil | 7048 | |||||||
| 20 | 19 | Dillon, Maxwell | 9180 | |||||||
| 21 | 20 | Creed, Victor | 3985 | |||||||
| 22 | 21 | Cassidy, Sean | 4362 | |||||||
| 23 | 22 | Blonsky, Emil | 4692 | |||||||
| 24 | 23 | Batroc, Georges | 2586 | |||||||
| 25 | 24 | Barton, Clinton Francis | 2665 | |||||||
| 26 | 25 | Baldwin, Robbie | 7807 | |||||||
| 27 | 26 | Astrovic, Vance | 3956 | |||||||
Sheet2 | ||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| D2,C2:C27 | D2 | =VLOOKUP(C2,Sheet1!$A$3:$G$30,MATCH(D$1,Sheet1!$A$3:$G$3,0),0) |
| A2:A27 | A2 | =ROW()-1 |
hi guys,
Is there a better way to get the value of the cell based on the row and column header. I use vlookup and match but once I try to use the formulae in the adjacent cell N/A due to lookup_value, so I always have to change it to the correct row header.
