| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
make it text in vlookup
I have a vlookup table like so:
234, 112 911, 999 260/1, 888 9W2, 777 .. etc.. The lookup works fine when there is text, ie. if I pass in "9W2", it returns 777 as expected. It does not work where there are only numbers eg. 234, it doesn't recognise that it should return 112. I have tried to make it treat it as text but nothing works. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a vLookup dynamic? | Excel Worksheet Functions | |||
| using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
| Help! ... need to vlookup but can't make it work! | Excel Programming | |||
| How to make text data export to excel in text format. | Excel Programming | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
Threaded Mode
