Trying to Match the result of
=LEFT(Z8,SEARCH("-",Z8)-1)
where
Z8="15-I81113"
and do a vlookup against a list with
15
corresponding to a product name
"Whipawhip"
Doesn't recognize the parsed out 15 as a match for the number 15.
How can I correct this?
Thank you, Rowland