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