VLOOKUP returning a #VALUE! error and I've not idea why! HELP!
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
|