S
Steve Haack
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
"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