| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Vlookup using text
Does Vlookup match text exactly? In other words if I have part number that's
got -, and alphanumeric characters, can Vlookup function in the table? If not, is there a workaround. I currently have a spreadsheet formatted as text and keep getting the #NA error even though I can do a manual search and find matches. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
| Looking up a string of text within a string of text | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| VLOOKUP first numerical value (not text) | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
