Need help in LOOKUP

[Mehmud Khan]

Hello,

Could anybody please see the attached file and provide me some solution!

I need a help in lookup with two conditions.

I tried it many times but unable to find the relevant solution.

Waiting for some response.

Thanks and Best Regards,
Mehmud Khan

 

[bosco_yip]

In D2, copied down :

=IFERROR(VLOOKUP(A2,F$3:H$5,MATCH(B2,F$3:H$3,0),0),IFERROR(VLOOKUP(A2,$J$4:$K$7,2,0),""))

Regards
Bosco

 

[Mehmud Khan]

Dear Bosco,

Thanks a lot for your instant reply.

And yes I found it suitable for my condition.

But Now I have one more query which I updated and highlighted in new file.

I know it will take a few moments to solve this.

Thanks in advance.

Mehmud.

 

[bosco_yip]

Dear Bosco,

Thanks a lot for your instant reply.

And yes I found it suitable for my condition.

But Now I have one more query which I updated and highlighted in new file.

I know it will take a few moments to solve this.

Thanks in advance.

Mehmud.

Try.......

In D2, copied down :

=IFERROR(VLOOKUP(A2,F$4:H$7,IF(B2="TAX",2,3),0),IFERROR(VLOOKUP(A2,J$4:K$7,2,0),""))

Regards
Bosco

 

[Mehmud Khan]

Dear Bosco,

Thanks a lot for your support.

It's really appreciable sir!

This is exact, what I am looking for from past 2 weeks..

Thanks once again, sir...



Regards,
Mehmud