LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DPR DPR is offline
external usenet poster
 
Posts: 4
Default lookup using multiple criteria

I'm trying to figure out a way to look up a value using multiple input
arguments. I've tried using the index() function but I can't quite get it to
do what I want. I'm trying to search through an array of electrical
components based on 4 different inputs. My components can be defined by
Type, Phase, Voltage, and Rating. I need to use these variables to find a
value in the next column which is a part number. My array would appear as
follows:

Type Phase Voltage Rating Part number
A 1 120 20 xxxxxx
B 3 240 32 xxxxxx
C 3 240 50 xxxxxx
....

The first three inputs (Type, Phase, and Voltage) should be exact matches,
however the Rating (amps) would most likely not match. I need my function to
return the part number of the component with the next higher rating than my
input. So if I type in that I want a type B, 3-phase, 240 volt, 35 amp
component, it would return the part number for my type B, 3-phase, 240 volt,
50 amp component. Any help would be appreciated. Thanks.
 
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 using multiple sheets and multiple criteria, sorry if 2 pos kjguillermo Excel Worksheet Functions 4 January 16th 07 03:21 AM
Lookup using multiple sheets and multiple criteria kjguillermo Excel Discussion (Misc queries) 2 January 14th 07 10:28 AM
Multiple Criteria Lookup GB Excel Worksheet Functions 3 October 3rd 06 11:55 PM
LookUp with multiple criteria mike47338 Excel Worksheet Functions 2 February 20th 06 11:42 PM
Multiple criteria LOOKUP Leon Excel Worksheet Functions 2 December 22nd 05 01:13 PM


All times are GMT +1. The time now is 08:43 AM.

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

About Us

"It's about Microsoft Excel"