LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I arrange tabs vertically in Excel (not horizontally)? LinLin Excel Discussion (Misc queries) 14 May 2nd 17 08:04 PM
Can't drag to align shapes vertically or horizontally mbaycura Excel Discussion (Misc queries) 0 March 4th 10 08:39 PM
how to search vertically then count horizontally in excel Novawitt Excel Worksheet Functions 2 December 14th 08 04:19 AM
extending a horizontally calculated formula vertically FoulDwimmerlaik Excel Discussion (Misc queries) 8 March 5th 08 01:30 AM
Move cells vertically to horizontally Abe Excel Discussion (Misc queries) 1 March 23rd 05 02:57 AM


All times are GMT +1. The time now is 04:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"