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