vlookup: can i specify the column with a name rather than a number

N

Nick

eg. if a setup an array and name it "array" and the column header in column 6
is "column 6 header", then rather than specify:

vlookup(A1,array,6,FALSE)

can i put the column header in rather than the number 6 (noting that)

vlookup(A1,array,column 6 header,FALSE)

doesnt work
 
Top