# VLOOKUP with two client rates

This formula is composed of two lookups for the same client. The first lookup finds the onsite rate for the client in column B and multiplies the result by the number of hours in column C:

=VLOOKUP(B5,rates,2,0)*C5

The second lookup finds the offsite rate for same client and multiplies the result by the number of hours in column D:

VLOOKUP(B5,rates,3,0)*D5

In the final step the two results are added together:

=(50*0)+(60*16) =960

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

## Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.