2 Vlookup's based on a variable?

[mackento]

Hoping someone can help me here!

As stated on the title, I'm trying to create a formula that will use either one of two VLookup formula's based on a variable that is in play.

=if(B3="Company1", (=vlookup(G3,'Table worksheet'!A:F,6,FALSE)), (=vlookup(G3,'Table worksheet'!A:F,5,FALSE)))

Essentially I want it to determine that if I choose company 1 or Company, it will import a rate dependant on the type of service selected in G3, and the rates are set out in a table in 'Table Worksheet', with column 6 being the rates for company 1, and column 5 being the rates for company 2.

Can anyone tell me if this is possible? It will be a Godsend if it is!

 

[mfexcel]

First of all, you don't need the equal sign in your IF True and IF False argument.
Secondly, you may probably rewrite your formula into sth like
=VLOOKUP(G3,'Table worksheet'!A:F,match(B3,header_range,0),false)
depends on how your table is set up...