HELP!! VLOOKUP, INDEX or MATCH??
Try this...
Assuming your lookup table is in the range A1:G4
A20 = 8
B20 = 2.2
=VLOOKUP(B20,$A$1:$G$4,MATCH(A20,$A$1:$G$1,0),0)
--
Biff
Microsoft Excel MVP
"Kurt" wrote in message
...
I am trying to figure out how to get a piece of information into a cell
needed for a calculation.
This is what I have in one worksheet:
8 10 12 15 18 21
2.0 0.138 0.155 0.132 0.121 0.105 0.083
2.2 0.156 0.175 0.152 0.143 0.130 0.111
2.4 0.174 0.194 0.173 0.167 0.155 0.138
The table keeps going...
B1:G1 are pipe sizes and A2:A4 are trench depths and in B2:G4 is CY/LF. In
a
different worksheet I have a cell that has the pipe size and a cell that
has
a depth of trench. What i would like to happen is when the pipe size and
depth of trench cells become populated on my other worksheet, i would like
a
formula in my CY/LF cell to take the pipe size and trench depth and
display
the value at the interesection of those two cells. (8 inch pipe with a
depth
of 2.2 should return me the number 0.156)
Any help would be greatly appreciated!
Kurt
|