VLOOKUP Issue

[Michael Kintner]

I have a value that is a numeric but the vlookup needs a text value of the
number. Any ideas on how to get the VLOOKUP to work with this?

Thank you in advance for any help....

Mike

 

[Bob Phillips]

=VLOOKUP(TEXT(value,"000"), lookup_range,2,FALSE)

change the TEXT format to suit.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)