I want to perform a Vlookup. My Look up value is an order number in the style
TSP1234 (where 1234 changes)
However my data table might have TSP1234/1
I want this to be a match.
Example
Excel 2000
This should return the value 8
=VLOOKUP(B1,LEFT(A3:B7,7),2,0) doesn't work
TSP1234 (where 1234 changes)
However my data table might have TSP1234/1
I want this to be a match.
Example
| Excel Workbook | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | Lookup Value | TSP1234 | ||
| 2 | ||||
| 3 | TSP1234/5 | 8 | ||
| 4 | TSP6789 | 5 | ||
| 5 | TSP7890/2 | 7 | ||
| 6 | TSP9876/1 | 9 | ||
| 7 | TSP6543 | 5 | ||
Sheet1 | ||||
This should return the value 8
=VLOOKUP(B1,LEFT(A3:B7,7),2,0) doesn't work
