Welcome to JustAnswer and thank you for utilising our services.
Are the CITY and STATE cells on the same row as the Output cell?
Thanks, ***** ***** that B2 and C2 are on the same row, I just need clarity on, where would you like you output to be? Would it be in D2 or somewhere else on the sheet such as say D50?
Ok. Thanks for the information, let me see if I can do it within 10 minutes.
I think I will need more time I'll opt out for now
Hello. I have a great deal of experience programming Excel and VBA macros. Can I help you with this? Is it possible to provide just a bit more detail about exactly what you want the spreadsheet to be doing? I have looked at your screen capture, and I'm still not sure precisely what you want. Thank you for your perseverance and, I suppose, drudgery :-)