Quote:
Originally Posted by wickedchew
Try:
=IFERROR(VLOOKUP(LEFT(A11,3),Table2,2,FALSE),VLOOK UP(LEFT(A11,3)&"*",Table2,2,0))
|
That only works for the ones that do have a wildcard on the table, but it doesn't work for the ones that don't use the wildcard.
Thanks