Re: VLookup returns #VALUE!

E7 is a number, so =ISTEXT(E7) = FALSE yes?

If you do the same to the 'number' in your table, does it also return FALSE?

Assuming for example, the matching number to E7 is in cell B12, if you do
=E7=B12 you get TRUE, yes?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------


"BEEJAY" <BEEJAY@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:21112AD8-8D6F-46F7-9A16-F2290C482634@xxxxxxxxxxxxxxxx
> Excel 2003;
> The following returns #VALUE!, which interferes with =SUM
>
> =VLOOKUP(E7,'L-Ups'!$B$8:$E$23,2,FALSE)
> The message is:" A value used in the formula is the wrong data type"
> I have taken all data, multiplied by 1, copy and paste special as value
> into
> tables.
> I have verified that cell E7 on the "L-Ups" *** is a number.
> I'm stuck.
> Any suggestions?
>


.