I have used vlookup on many occasions without any problems, however, to day
for some reason it is not working. Below is the look up range and I want to
return the value 5.810, 3.410 ... in another table. I am getting N/A# Is
ther something I am missing.

9205241003 5.810
9203220002 3.410
9204230001 3.500
9203266002 3.810
9203282005 4.660

--
thanks as always for the help
jer

Can you post your formula?


"jer" wrote:

I have used vlookup on many occasions without any problems, however, to day
for some reason it is not working. Below is the look up range and I want to
return the value 5.810, 3.410 ... in another table. I am getting N/A# Is
ther something I am missing.

9205241003 5.810
9203220002 3.410
9204230001 3.500
9203266002 3.810
9203282005 4.660

--
thanks as always for the help
jer

thanks Al, oversight on my part problems sorted out
--
thanks as always for the help


"Al" wrote:

Can you post your formula?


"jer" wrote:

I have used vlookup on many occasions without any problems, however, to day
for some reason it is not working. Below is the look up range and I want to
return the value 5.810, 3.410 ... in another table. I am getting N/A# Is
ther something I am missing.

9205241003 5.810
9203220002 3.410
9204230001 3.500
9203266002 3.810
9203282005 4.660

--
thanks as always for the help
jer