Tuesday, March 10, 2015

yogi_Pull Names of Sponsored (Referrlas) From Column D For Sponsors In Column E


                                           Google Spreadsheet   Post  #1916
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Mar 10, 2012
question by Kieron Garvey:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/7f-JWpw05VA
Lookup problem

Im trying to do something but just cant manage it.

If you look at the image above you will see Username, Sponsor, Referral 1, Referral 2. 

Now what i want to do with a formula is E&F or how ever i can do it to search Sponsor for using the corresponding usersname and if there is none i want to place No referrals in the referral 1 & referral 2. There will only ever be 2 referrals. Ive spent hours doing it but cant get it right.

I've tried Arrayformula, lookup and loads of other ways but new to spreadsheets and cant master this

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