VLookup problems...
the contents of that cell.
"RagDyeR" wrote:
How would B59856 *ever* be a number ... if that's what you see in the
formula bar?
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
"daddylonglegs" wrote in message
...
Assuming defined range clear is correctly defined then most common cause of
what you describe is data mismatch. If B59856 is a numeric value, not text,
then the lookup range should be too.Test with
=ISNUMBER(B59856) and
=ISNUMBER(X288)
where X288 is the cell that should match B59856, do you get TRUE for both?
|