Hi Dave,

Reg is not a named range as I'm not entirely sure what that means or how to
do it.

I have tried using cell reference B1 as my list covers column b and c
instead of Reg but it still brings back an error message.



"Dave" wrote:

Hi,
The first argument in VLOOKUP should be a single value or cell.
I assume Reg is a named range? If Reg is the name of more than one cell, you
will get errors. If you are getting a Name? error, it means XL doesn't
recognize the name Reg.
Also, if you only have 2 columns, are they Column B and Column D?
Regards - Dave


"forevertrying" wrote:

The formula is:

=F22*VLOOKUP("Reg",$B$1:$D$16,3,FALSE)

F22 is the total hours (result of a sum totalling all hours in the row)
The table it is looking the information up from is
Column 1 = Reg
Column 2 = Hourly Cost

There are 16 Reg Numbers and therefore 16 hourly costs. The Hourly Costs are
formatted as currency.