In my worksheet, I have:
[Y2]
=MID(D2,FIND("@",D2),7)
Sometimes it returns "#VALUE". I want it to look in another column if that comes up. I would think to use an IF formula to do this. But if I do:
[Z2]
=if(Y2="#VALUE", G2, "")
Unfortunately that doesn't work. How can I just use an IF formula on the MID function to catch the error? Thanks in advance!!!
[Y2]
=MID(D2,FIND("@",D2),7)
Sometimes it returns "#VALUE". I want it to look in another column if that comes up. I would think to use an IF formula to do this. But if I do:
[Z2]
=if(Y2="#VALUE", G2, "")
Unfortunately that doesn't work. How can I just use an IF formula on the MID function to catch the error? Thanks in advance!!!