VLOOKUP(T12 is the vertical lookup
MATCH(E12 is the horizontal lookup

MATCH(E12,'TBF TABLE'!$C$2:$Z$81,0)

The horizontal lookup array *must* be a single row. Try:

MATCH(E12,'TBF TABLE'!$C$2:$Z$2,0)

Here's an example:

...........A..........B..........C..........D
1....................x............y..........z
2........5..........3...........8..........6
3........7..........4...........1..........2

To lookup 5 and y:

A10 = 5
B10 = y

=VLOOKUP(A10,A1:D3,MATCH(B10,A1:D1,0),0)

Result = 8

--
Biff
Microsoft Excel MVP


"Kurt" wrote in message
...
Here is what I put in:
=VLOOKUP(T12,'TBF TABLE'!$C$2:$Z$81,MATCH(E12,'TBF TABLE'!$C$2:$Z$81,0),0)
with T12 being my depth cell in my calc tab (worksheet) and E12 is my pipe
size in my calc tab (worksheet).
and here is what i get when with that formula: #N/A

"T. Valko" wrote:

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