Multiple IF's and Lookups

Ok so I'm doing some excel invoices and can't for the life of me remember how to do what I need it to do.

Since we will have a few users it needs to be as simple as possible so we are using drop down boxes, one box with the code for the equipment being sold and another for for what discount section they are in

Now I have 4 other tabs with the pricing for these discounts and I want it to lookup for example
Discount code is f1 then go to the tab labelled f1 and produce the information for the equipment code (ex gst, gst, discounts etc) that is in the second drop down box

Someone suggested multiple if statements with a vlookup both of which I can do seperately but just can't make it work together

Thanks!