selecting a result from multi conditions

**Ranbir** · 05-05-2009, 10:03 AM

Dear Friends,

I have attached a file, in which i need to get the value for IHC from a table using formula as the conditions will vary from time to time. The table is only a sample.. actually it had much more.

Thanks in anticipation.

Ranbir

**Domenic** · 05-05-2009, 05:06 PM

Try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER...

=INDEX(C15:F19,MATCH(1,IF(ISNUMBER(SEARCH(B2,A15:A19)),IF(B15:B19=B3,1)),0),MATCH(B4,C13:F13,0)+(B5="> 12 Mt to <=20 Mt"))

Note that if A17 contains MAERSK instead of MAERSK LINE, you can replace...

ISNUMBER(SEARCH(B2,A15:A19))

with

A15:A19=B2

Also, cell C13, which contains DADRI, also contains a trailing space. You'll need to remove it, otherwise there won't be an exact match and the formula will return #N/A.

**mubashir aziz** · 05-06-2009, 03:42 AM

Just see the attach file i've given some suggestion which might be helpful for you ... i always tried to keep data just like a data base which is help full for sake of any reporting especially you can use a very useful tool Pivot Table ...... anyway just check it out ....

**Ranbir** · 05-06-2009, 09:43 AM

Dear Aziz,

seems the suggestion given by you is working.. i will put the same in my actual worksheet and give you the feedback.... meanwhile thanks for the prompt reply.

Ranbir

**Domenic** · 05-06-2009, 10:14 AM

Have you tried the solution I offered? I believe it should return the desired results without having to re-arrange your data, if that's your preference. I've attached a sample file for you to look at.

**Ranbir** · 05-08-2009, 06:30 PM

Dear Domenic,

I tried the both the solutions offered by you and aziz, since the prob i mentioned is 1 part, i am trying you solution on the other part also... thats why i didn't replied.... will get back to you once completed my assignment.....

thanks for your early and prompt reply....

this section is still open for me as my job is still half finished....

Ranbir