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
------------------------------------------------------------------------------------------------------------------------------------
Lookup problem
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
------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment