Help with If & Index and Match

[Sean15]

Hi:

Could you help me solve this please?

Column G has values like API0001521 or EE0001625

L2 has formula =IF(G2="API*","",INDEX and Match formula)))

Excel is returning #N/A and not "" if G2 has value API... INDEX and Match is returning required value if value in G2 is not API

Could you help please?


Regards,

Sean

 

[Peter_SSs]

Try
IF(LEFT(G2,3)="API","",....

 

[Sean15]

Excellent, thank you very much.


Regards,

Sean