Hello guys ,
I would need help with my excel document, I have managed to do a dropdown list, in Cell A, and then if it shows a name, it coppies down the second column B2 from the source lists, (=IF(ISTEXT(A5),VLOOKUP(A5,list,2),"") and the same for the Cell C which is for an email adress (=IF(ISTEXT(A5),VLOOKUP(A5,list,2)
everyting works just fine, but the problem is that in order to send email which is cell 3, instead of the email address it shows the formula and VBA in this instance dont work. as the VBA code is referenced to C column there it should catch an address and not a formula,
Is there away to keep the formula, but hide it and show the result only ?
Please find document attached
Many thanks,
Aivaras
Bookmarks