VLOOKUP requires the column of the table. Your table conveniantly has the
column numbers offset by 1. If you had random numbers, or text, for the
column headings, it would require a different formula.

"Stuart Carnachan" wrote:

Cheers that works but what is the methodology behind it ?
--
Stuart


"Sloth" wrote:

=VLOOKUP(A1,C2:I3,A2+1,0)

this assumes the table is in C1:I3 (I put "GRADE" in cell C1), so replace
"C2:I3" with the location of your table.

"Stuart Carnachan" wrote:

I WOULD LIKE TO CROSS REFERENCE A TABLE AS BELOW TO PICK OUT THE VALUE
in A3 if i input "Training" in A1 and grade "3" in A2.Conversley if i change
to driver and grade it will pick up the cross reference value


GRADE 1 2 3 4 5 6
Training 60 65 75 80 90
95
Driver 65 75 80 85 95
100

Stuart