All
I am seeking assistance in how to select the relevant address for use from three lists were the address may be recorded. Please see attached file for example....
I have the preferred name in column C, however if this is blank go to Column D else use Column B and paste preferred Name in Column E.
I am guessing an if statement would work but unsure how to write it to do this....
Any assistance greatly appreciated....
rgds
shaz5053
Bookmarks