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     www.energyefficientbuild.com.    Apr 29, 2013
user Charlene On Green (https://productforums.google.com/forum/#!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?

Thanks!

---

Yogi, thanks for your response here is a sheet

 

https://docs.google.com/spreadsheet/ccc?key=0AsgsqMHzLkIWdENxRWpPbU5MRDlZRmVuSU5jNXRTUEE&usp=sharing

 

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ʺ

 

Thanks!

-----------------------------------------------------------------------------------------------------------------------

following is a solution to the problem