Hi Kevin

Tua'r Goleuni
Were you at Cardiff High School?

--
Regards

Roger Govier


"Ponty'NPop" wrote in message
...
Hi Trevor,

Perhaps,

Name the cell TotalYY and reference that name thereafter?

HTH,
--
Kevin James.
Tua'r Goleuni


"trevor_tito" wrote in message
...
| Hi,
|
| I am trying to determine the column index number in a vlookup with a
matcxh
| function but I'm getting an #N/A error message.
|
| The table I am looking up may change in shape (e.g. not always the
same
| number of rows or columns) so I have given this a name range.
|
| The table (called NAME_RANGE) is basically
|
| ZZ YY XX
| A 10 40 70
| B 20 50 80
| C 30 60 90
| TOTAL 60 150 240
|
| The formula I am using is more or less:
|
| =VLOOKUP("TOTAL",NAME_RANGE,MATCH("YY",NAME_RANGE) ,FALSE)
|
| I should get 150.
|
| What have I done wrong?
|
| Cheers
| TT
|