Thread: vlookup
View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default vlookup

=INDEX(A1:B3,MATCH(A5,B1:B3,0),1)
.... where your sample data is in A1:B3 and the letter A is in cell A5.