LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default lookup a number based on multiple criteria

I have a list with two possible numbers but each number has several criteria

A1 B1 C1
DIAMETER LENGTH MAX WEIGHT
70 48 368
70 60 245
70 72 145
100 48 700
100 60 550
100 72 450


I am looking for the result from column a based on both the length and
weight which is located on another worksheet say cells f15 for the length and
k15 for the weight. I have tried this formula but it always returned the
same resulkt of 70 which is incorrect.
INDEX($AP$3:$AP$36,MATCH(1,('ROLL CUT
SHEET'!M27<=FORMULAS!$AQ$3:$AQ$36)*(FORMULAS!AG15 =$AR$3:$AR$36),0))) using
ctrl+shift+enter.


Thank you so much for assistance in advance.

 
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 and Display Multiple Unique values based on criteria MPI Planner[_2_] Excel Worksheet Functions 8 December 26th 09 08:42 PM
Lookup and Display Multiple Unique values based on criteria MPI Planner[_2_] Excel Worksheet Functions 2 December 11th 09 03:06 PM
Lookup based on multiple criteria John Calder New Users to Excel 5 May 6th 09 06:53 AM
Index/Match - Lookup based on multiple column criteria Slider Excel Worksheet Functions 3 March 22nd 07 06:34 PM
Lookup based on two criteria in 1 row BethP Excel Discussion (Misc queries) 3 April 12th 05 06:47 AM


All times are GMT +1. The time now is 06:52 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"