Hi Niek,

I have ahad a quick look at that page and am already confused.

I have named the range of cells using offset as it says. The next part is
where I'm baffled. It says in the example that the code it is looking for is
in A7. I thought it would pick the right code/reg out of a list. If I have to
right a formula that says which cell it is in, it kind of defeats the object.

Is VLOOKUP even the right thing for me?

"Niek Otten" wrote:

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.
|