## VLOOKUP with two client rates in Excel

This tutorial shows how to calculate VLOOKUP with two client rates in Excel using the example below; Formula =VLOOKUP(client,rates,col,0)*hrs+VLOOKUP(client,rates,col,0)*hrs Explanation To lookup two different rates for the same client, and calculate a final charge, you can use a formula based on two VLOOKUP functions. In the example shown, the formula in E5 is: =VLOOKUP(B5,rates,2,0)*C5+VLOOKUP(B5,rates,3,0)*D5 where …