VLOOKUP Issue

  • Thread starter Thread starter Michael Kintner
  • Start date Start date
M

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
 
=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)
 
Back
Top