Lookup data (index/match?)

[normpam]

F G H
CUSTOMER SERVICE RATE
Sam QB $120.00 result of formula: =INDEX(qb,MATCH(F2,customer,0)) On Sheet2 I have named a vertical list of the customer names as 'customer'
Ed Consulting Also on Sheet 2 are three columns with rates for Consulting, QB and LGQB. My
Bob LGQB My formula works fine to look in the range I named for 'QB', finds the customer, and
Bob LGQB brings over the rate.
Bob QUESTION: How can I get the formula to look up the rate not based on a specific range like 'QB' but based
Ed LGQB on the type of service indicated in column G?
Sam Consulting Thanks much for any help!
Sam Consulting
Ed QB

 

[normpam]

Just saw that my post did not work... will retry

 

[normpam]

What formula would work to get the rate not just for the specified range 'QB', but based on whatever service is indicated in column C?
Thanks for any help!