Sorry,

the col_index_num is actually 2. I had been playing with it and not changed
it back.

"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