matching values based on criteria and return values from another columns

**lizard54** · 09-06-2012, 10:40 AM

I have data consists of 4 columns. I would like to return the value in column1 and column4 based on the criteria (1) if column2 match user inputs valude, (2) column 3 equals to D, and (3) column 4 <= 3. I have tried lookup and match and couldn't seem to make this to work. Wonder if this need to be done in VBA or using Excel formula?

I appreciate any advice / help anyone can provide. Thank you much.

**Special-K** · 09-06-2012, 11:20 AM

Your results are incorrect

You say
If user input in cell B2 (your example sheet says the user input is in B1)

...match value in column 2
If column 3 = D
If flag value >=1

then output should be

A 1
G 2

Considering rows where column A = G
Row 6 column B does not B1
Row 7 column 3 does NOT = D

so the only output would be

A 1

no G's

This formula works

Please Login or Register  to view this content.

**lizard54** · 09-06-2012, 11:29 AM

Thanks for your inputs, Special-K. Actually, I meant to put the D in cell C7. I would like to look at the array and generate the output as in:
A 1
G 2

What would be a good way to work with array? Thank you in advance.