=INDEX(NAME_RANGE,MATCH("TOTAL",A1:A5,0),MATCH("YY ",A1:D1,0))


"trevor_tito" wrote:

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