Monday, April 29, 2013

yogi_If Store Number Exists In Areas Sheet Column A Mark In Orders Sheet Yes Otherwise Mark No

                                          Google Spreadsheet   Post  #1161
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr 29, 2013
user Charlene On Green (!mydiscussions/docs/4ABVuEHA8vI)

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?
Yogi, thanks for your response here is a sheet
on the sheet called "orders" I want to know if value in ROW 2 matches up with value in column A on ʺareas sheetʺ then type in the word ʺYESʺ, otherwise type ʺNOʺ
following is a solution to the problem