LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default Lookup from an array

I have an array which has 26 pipe diameter sizes in column A ( from A203 to
A228.) It has 17 pipe thickness across Row 202 ( from B202 to R202). At the
intersections of the array are the pre-determined welding hours to suit the
particular pipe size / pipe thickness.
Toward the top of the spreadsheet, I am using 2 data validation lists in
adjacent cells B3 and C3 where I select the pipe size (B3) and select the
pipe thickness (C3).
I need a formula to enter into cell D3 which will display the resultant
welding hours from the array below, based on the size and thickness that are
selected at B3 and C3.
Any help would be appreciated.

GrantW

 
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
Lookup array RD Wirr Excel Worksheet Functions 5 February 13th 07 01:29 PM
Lookup an array Chris_t_2k5 Excel Discussion (Misc queries) 2 March 2nd 06 01:39 PM
Lookup "greater than or equal to" in lookup array icemouse New Users to Excel 3 February 16th 06 10:07 PM
IF ARRAY LOOKUP ??? Help Please Ellen G. Excel Worksheet Functions 6 February 13th 06 11:46 AM
How do I use <= in a lookup array? Gdog34 Excel Discussion (Misc queries) 0 June 29th 05 09:42 AM


All times are GMT +1. The time now is 11:48 PM.

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"