Earlier I posted a question on how to find partial text within a specified range. The solution that was given was to use:
[quote][b][u]zorvek:[/b][u
]
=VLOOKUP(Z1&"*",A1:B14,2,F
ALSE)
Where Z1 contains the partial job number.[/quote]
[url=
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23439163.html#a21663192]Link to original question[/url]
The problem with this formula is that if I have anything after the decimal that doesn't match the list, then it comes up with an "N/A" error. I was wondering if there was a way to lookup the partial value (everything to the left of the decimal). For example, I want to find the Job Name associated with all 08-001 values (formatted as text). So even if the user put in "08-001.9954" it would still only look up the "08-001" value in the Job List provided.
Attached is an example worksheet that shows the error I'm getting.
Start Free Trial
