Maybe you should have a fresh start again.
Read this tutorial about VLOOKUP:
http://www.contextures.com/xlFunctions02.html
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"forevertrying" wrote in message
...
| 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.
|