Matching Multiple Conditons

1. Matching Multiple Conditons

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

2. Re: Matching Multiple Conditons

This maybe?

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

3. Re: Matching Multiple Conditons

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

4. Re: Matching Multiple Conditons

Try this:

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

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

5. Re: Matching Multiple Conditons

Dear zbor

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

6. Re: Matching Multiple Conditons

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?

7. Re: Matching Multiple Conditons

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

8. Re: Matching Multiple Conditons

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.

9. Re: Matching Multiple Conditons

thanks zbor

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1