With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, April 29, 2013
yogi_If Store Number Exists In Areas Sheet Column A Mark In Orders Sheet Yes Otherwise Mark No
I have a sheet of stores sorted by store #, lets call this sheet1, I have another sheet that the reps fill out, lets call this sheet2. If a rep enters the store number on sheet2, I want to check if that store is in my territory on sheet1. If the store is in my territory I want to put "IN" on the row 3 below the store number that the rep put in.
What kind of array or if statement would I use for this?