I am trying to create a forumula that will auto-generate my Provincial
(State) and Federal Tax based on where my customer is.

I have five different tax regions (this will expand) and I have two
possible tax calculations per region.

I need the amount entered to calculate the tax based on the tax region;
coded 1-5

I have tried using a combination of IF and VLookup but my syntax just won't
gel.

Can anyone help?

Thanks