| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Issue with VLOOKUP | Excel Worksheet Functions | |||
| am not sure if its a vlookup issue | Excel Discussion (Misc queries) | |||
| VLOOKUP issue | Excel Worksheet Functions | |||
| VLOOKUP issue | Excel Discussion (Misc queries) | |||
| Vlookup issue | Excel Programming | |||
Linear Mode
