Looking up for value vertically and horizontally simultaneously

  • Thread starter Sanjeev Raghavan
  • Start date

S

Sanjeev Raghavan

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.
 
Ad

Advertisements

M

Mike H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ACF Newsreader Stats 11
Need help tidying up a report 2

Top