Hi John Topley,

Your formula working fine at G4 & G7, but shows #N/A in F4. Ex: HY-05840 appears in 3 places and and when i put "E" in one of the cells in Col. C, the answer is working fine in G4 but F4 shows #N/A, but it should show HY-05840.

Thanks,
Nagesh.