ExcelBanter - VLOOKUP Issue

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VLOOKUP Issue (https://www.excelbanter.com/excel-programming/286867-vlookup-issue.html)

Michael Kintner

VLOOKUP Issue

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[_6_]

VLOOKUP Issue

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

"Michael Kintner" wrote in message
...
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

All times are GMT +1. The time now is 11:18 AM.