Matching multiple critierion across multiple columns

I suggest you post a small sample workbook.

Thanks Form Guru for your response. As suggested I have uploaded a sample workbook.

The matching in the example is for Cell A2 in Sheet1 to Column A in sheet2; cell B2 in sheet1 to Column B in Sheet2 and cell C2 in sheet1 to column F in Sheet2. The table in sheet2 stores the sales tax rates which change from time to time. Provision has been made for a surcharge and cess which is introduced for some years. Currently these are not applicable hence the forced 0 in columns C and D. The surcharge and cess are calculated on the tax value, hence I use the total column to get the final percentage to be charged when the rate is applied rather than calculate this for every transaction.

Hope this would clarify your queries

Have you removed your attachment - it seems to have disappeared? In any case please could you upload again?

Attaching the file. Cant understand how this disappeared.

Very mysterious, might be a problem with the forum. See if this does what you want:

Please Login or Register  to view this content.

Thanks StephenR for your effort. Will try this code out and get back to you.

Tried out the code. Worked like a charm. Thanks a lot for your help