Looking for tips/tricks for the following scenario - Need ot be able to if
then through approx 7-10 pieces of criteria and then present result - any
suggestions greatly appreciated

Jim,

Not exactly sure what the relationship between these 7-10 pieces of criteria
are, so it's hard to make a recommendation. Do all of the 7-10 pieces have
to be compared against all the others?

(I'm assuming that you're having to do this in Excel formulas, rather than
VBA)

If it's just a matter of looking for a row that has "BLUE" in column A and
"USD" in column B and "Y" in column C, etc., how about using a combination
of IF and AND?

=IF(AND(A1="BLUE", B1="USD",C1="Y"), "HIT", "MISS")

Good luck,

Mark

Hi,
If you are going to use code, it might be easier to use a Select Case
format, with this many criteria.

Thanks,

"Jimc" wrote:

Looking for tips/tricks for the following scenario - Need ot be able to if
then through approx 7-10 pieces of criteria and then present result - any
suggestions greatly appreciated

Mark,
There are 9 cells with drop down lists in them - the criteria that is chosen
in the drop down lists is what sets the criteria that i need answered and
populated into other cells - The end result that i am looking for is to be
able to qualify & quantify data entered against fixed data...if you have any
suggestions greatly appreciated

"Mark Dev" wrote:

Jim,

Not exactly sure what the relationship between these 7-10 pieces of criteria
are, so it's hard to make a recommendation. Do all of the 7-10 pieces have
to be compared against all the others?

(I'm assuming that you're having to do this in Excel formulas, rather than
VBA)

If it's just a matter of looking for a row that has "BLUE" in column A and
"USD" in column B and "Y" in column C, etc., how about using a combination
of IF and AND?

=IF(AND(A1="BLUE", B1="USD",C1="Y"), "HIT", "MISS")

Good luck,

Mark

You could use the dropdown selections as criteria for an advanced
filter, and return matching records from a list. There are instructions
in Excel's Help, and he

http://www.contextures.com/xladvfilter01.html

And there are sample files here, that may help you get started:

http://www.contextures.com/excelfiles.htm

Under 'Filter', look for 'Product List by Category'

Jimc wrote:
Mark,
There are 9 cells with drop down lists in them - the criteria that is chosen
in the drop down lists is what sets the criteria that i need answered and
populated into other cells - The end result that i am looking for is to be
able to qualify & quantify data entered against fixed data...if you have any
suggestions greatly appreciated

"Mark Dev" wrote:


Jim,

Not exactly sure what the relationship between these 7-10 pieces of criteria
are, so it's hard to make a recommendation. Do all of the 7-10 pieces have
to be compared against all the others?

(I'm assuming that you're having to do this in Excel formulas, rather than
VBA)

If it's just a matter of looking for a row that has "BLUE" in column A and
"USD" in column B and "Y" in column C, etc., how about using a combination
of IF and AND?

=IF(AND(A1="BLUE", B1="USD",C1="Y"), "HIT", "MISS")

Good luck,

Mark






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I think the max nested if is seven and it really gets harry, even at seven.
Still not clear what your final objective is here? You want to simply see if
you have something in stock, based on 7-10 criteria?

Thanks,

"Jimc" wrote:

Looking for tips/tricks for the following scenario - Need ot be able to if
then through approx 7-10 pieces of criteria and then present result - any
suggestions greatly appreciated