Looking up for value vertically and horizontally simultaneously
 

I have a table with vertical dimensions of pipes and thickness of pipes
horizontally as below.

NPS OD CIRCM 25 30 35 40 45 50 55
3 4 5 6 7 8 9 10
0.125 10.3 0.01 0.2 0.2 0.3 0.3 0.3 0.3 0.4
0.25 13.7 0.01 0.2 0.2 0.3 0.3 0.3 0.4 0.4
0.375 17.1 0.02 0.2 0.2 0.3 0.3 0.3 0.4 0.4
0.5 21.3 0.02 0.2 0.3 0.3 0.3 0.3 0.4 0.4
0.75 26.7 0.03 0.2 0.3 0.3 0.3 0.4 0.4 0.4
1 33.4 0.03 0.3 0.3 0.3 0.4 0.4 0.4 0.5

That is, vertically from row 1 to 8 and horizontally from column a to j

I need the result in other sheet

NPS THK WEIGHT

0.125 25 ?
0.25 25 ?
0.375 30 ?
0.5 35 ?
0.75 40 ?
1 45 ?


Please advice is it possible and how if possible.

Looking up for value vertically and horizontally simultaneously
 

Hi,

Try this

=INDEX(A1:J8, MATCH(K1,A1:A8,0), MATCH(K2,A1:J1,0))

Where k1 is the lookup valu for column A and K2 is the lookup value for row 1
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Sanjeev Raghavan" wrote:

I have a table with vertical dimensions of pipes and thickness of pipes
horizontally as below.

NPS OD CIRCM 25 30 35 40 45 50 55
3 4 5 6 7 8 9 10
0.125 10.3 0.01 0.2 0.2 0.3 0.3 0.3 0.3 0.4
0.25 13.7 0.01 0.2 0.2 0.3 0.3 0.3 0.4 0.4
0.375 17.1 0.02 0.2 0.2 0.3 0.3 0.3 0.4 0.4
0.5 21.3 0.02 0.2 0.3 0.3 0.3 0.3 0.4 0.4
0.75 26.7 0.03 0.2 0.3 0.3 0.3 0.4 0.4 0.4
1 33.4 0.03 0.3 0.3 0.3 0.4 0.4 0.4 0.5

That is, vertically from row 1 to 8 and horizontally from column a to j

I need the result in other sheet

NPS THK WEIGHT

0.125 25 ?
0.25 25 ?
0.375 30 ?
0.5 35 ?
0.75 40 ?
1 45 ?


Please advice is it possible and how if possible.