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. |
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. |
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. |
All times are GMT +1. The time now is 03:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com