Matching Multiple Conditons

[Azam Ali]

Hi All

i need the help to apply multiple conditions to pick a value. A worksheet is enclosed in 2007 vers. in the cell # E7 & E8 i need the answer as 8 through vlookup or some other formula.

Further, i have formula in two columns. Is there any formula which could be applied in one column only.

thans

[zbor]

This maybe?

=SUMIFS(D:D, A:A, A1, B:B, B1, C:C, C1)

[Azam Ali]

hi zbor

this sumif formula is giving same answer as in the column D, it is shoing error in row no 2,3,5,6 & 7. I need value in these rows as shwon in column E of my attatchment

thanks

[zbor]

Try this:

=MIN(IF($A$1:$A$100=A1,IFERROR($D$1:$D$100,"")))

Comfirmed with ctrl+shift enter (not just enter).

[Azam Ali]

Dear zbor

thanks for your repoly as it is giving the desired answer.

Kindly inform about the possibility to combine the formula in column D with this formula

i also dont understand the logic. could you guide me to learn such formulas

thanks again

[zbor]

Actually, I didn't look your formula in D column before...

If you want to join them together, now that I check it, you can try this:

=MATCH(A1&"prd", INDEX($A$1:$A$30&$B$1:$B$30,,), 0)

(normal enter)

but this doesn't look C column which I didn't see why it's important in your case?

[Azam Ali]

Dear zbor
this formula is more better and you are correct that C column is not needed.

thanks a lot


could you guide me to learn such formulas

thanks again

[zbor]

Easies is to click Evaluate Formula button in the Formulas tab.

=MATCH(A1&"prd", INDEX($A$1:$A$30&$B$1:$B$30,,), 0)

MATCH will try to find:
A1&"prd"
in the array that has exact match (0)

Array is created from your two columns: A and B as INDEX($A$1:$A$30&$B$1:$B$30,,)

So from 11122233 and prd con con prd con con con prd it will create:

1prd 1con 1con 2 prd 2con 2con 3con 3prd

So, matching each number in A column 11122233 and "prd" will return you first instance in the array.

[Azam Ali]

thanks zbor