View Single Post
  #2   Report Post  
Mangesh
 
Posts: n/a
Default

A B C D E
1 1 2 3 4
2 1 a b c d
3 2 e f g h
4 3 i j k l
5 4 m n o p


Use:
=VLOOKUP(A4,A2:E5,MATCH(C1,B1:E1,0)+1)
to get j

Mangesh



"steve goundry" <steve wrote in message
...
i want to reference a table type price list, using height and width, 2
sources. How do i do it???