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
Bookmarks