I've got the list on the same worksheet, up above it, as I couldn't get it to
notice the list when I put it anywhere else.

I've tried changing it and it now says #N/A

Think I've been through just about every error message there is now! I just
don't understand how I'm having such difficulty.

This should be fairly easy surely?



"Niek Otten" wrote:

I thought you had column A named Reg.
Use A1 instead of Reg.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"forevertrying" wrote in message
...
| Tried that one, but then it just brings up #NAME?
|
| "Niek Otten" wrote:
|
| Omit the quotes around Reg
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "forevertrying" wrote in message
| ...
| | 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.
| |
| |
| |
| | "Dave" wrote:
| |
| | Hi,
| | You probably don't need to email your sheet.
| | Just show us a copy of the formula you're using, and some details of the
| | data table you're trying to look up.
| | Regards - Dave.
| |
| | "forevertrying" wrote:
| |
| | Hi there,
| |
| | I am using VLOOKUP to calculate vehicle usage hours... or should I say, I am
| | TRYING to use.
| |
| | It keeps sending back a #VALUE! error and I have absolutely no idea why. I
| | have used all the help I can possible find, and I can't see where its going
| | wrong.
| |
| | I can e-mail my worksheet for someone to have a look at. I'm fairly sure its
| | a simple thing to fix, but, as I can't do it myself, I must be simpler ;o)
| |
| | Thank you in advance
| |
| |
|
|
|