vlookup with more than 2 criteria

Hi,

Can you help solve the attached file...
I am getting a false result....

Thanks in advance!!!

Lin

I think this will solve all of your issues in the sheet. Used some named ranges, and changed some forumlas to make it adjust to new changed entries.

- Vince

Dear Vince,

So happy you solve it for me, actually this is part of my assignment as I am training for excel advance, but the INDIRECT function is not yet discuss with us so not fully aware how to use it.

So far only combination on IF,OR,AND, and Vlookup has taken on, so possible combining these function on the said worksheet??

Appreciate very much if you can help me with these....

Thank you so much!!!!

Have a nice day ahead.

Lin

Deleted; Wrong thread!