| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing Table Data
In Excell 2007, I have a Table defined as "Scores" with Column's Named
"Name", "Front", "Back", and "TotalScore". I want to do a VLOOKUP to find the total score for Mike. When I do this: =VLOOKUP("Mike",Scores,4,FALSE) it will return Mike's total score for me. But, if I do this: =VLOOKUP("Mike",Scores,Scores[TotalScore],FASLE) it will give me a #REF! error. How can I use VLOOKUP along with the Column names to do a lookup? It is possible, that as I make changes to the sheet, the columns may move around, and I don't want to hard code anything. Thanks, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 - Referencing data in a table to use in formulas | Excel Worksheet Functions | |||
| referencing data to a table | Excel Worksheet Functions | |||
| Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
| referencing data from a table | Excel Worksheet Functions | |||
| Referencing Data in a Pivot table. More Excel 2003 misery | Excel Worksheet Functions | |||
Threaded Mode
