Explanation
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
Related formulas
VLOOKUP calculate shipping cost
This example shows how to use the VLOOKUP function to calculate the total shipping cost for an item in one formula, where the cost per kilogram (kg) varies according to weight. This requires an "approximate match" since in most cases the actual weight will not appear in the shipping cost table. For...
Related functions
VLOOKUP Function
The Excel VLOOKUP function is used to retrieve information from a table using a lookup value. The lookup values must appear in the first column of the table, and the information to retrieve is specified by column number. VLOOKUP supports approximate and exact matching...
Related videos
How to use VLOOKUP
VLOOKUP is one of the most important lookup functions in Excel. The V stands for "vertical" which means you can use VLOOKUP to look up values in a table that's arranged vertically. Let's take a look. Here we have a list of employees in a table. Let's use VLOOKUP to build a simple form that...
