Thread: lOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stuart Carnachan Stuart Carnachan is offline
external usenet poster
 
Posts: 11
Default lOOKUP

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