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:
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