I'm not sure if my picture is showing on this thread....

Column A has no formula
B6 has a left formula taking the first 7 characters of cell A6
C6 has a formula that takes the information in B6 and VLookups an ISN Grade on a different Excel Workbook e.g. A,B,C,F

=IFERROR(VLOOKUP(B6,'ISNGradeReport'!$C$1:$D$65536,2,FALSE),"NA")

My issue is if the ISN Grade Workbook has multiple account numbers in the cell. Can I add an embedded search formula in the VLookup?

Thank you!


excel forum.JPG