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. |
#2
|
|||
|
|||
Vlookup using text
Likely, your range to look in is incorrect. Usual syntax:
=vlookup(a1,sheetname!$A$1:$D:$500,false) You need the false if the column in your lookup range is not sorted. ************ Anne Troy www.OfficeArticles.com "gersumabat" wrote in message ... 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. |
#3
|
|||
|
|||
Vlookup using text
Is the data sorted? If so, add ,False at the end
=VLOOKUP(value,lookup_table,col, False) -- HTH RP (remove nothere from the email address if mailing direct) "gersumabat" wrote in message ... 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. |
Reply |
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) |