looking for some help with a a Google Sheets formula— downloaded it into excel.
Cell B2 can have two response options, ABC or NEW.
Essentially i'm looking for a vlookup formula in B12:C14 that would only apply if B2= ABC and one of the KPIs are Affinity
If both options are met, then the Vlookup would pull from N4:O4, instead of columns L&M
again, this is ONLY applicable when ABC & Affinity are selected. Anything else could use columns L&M for the VLookup
thanks!
Last edited by michlam; 05-28-2021 at 09:06 AM.
How would i correct my formula for this particular case? Currently it's just a straight forward vlookup. I would want the formula to nimble so that if the condition is:
- B2= NEW
- Primary KPI= Familiarity
- Secondary KPI= Purchase Intent
It would just pull from columns L&M
BUT if:
- B2= ABC
- Primary KPI= Affinity
- Secondary KPI= Purchase Intent
Cell B12, would pull from columns N & O, but Cell 13 would pull from columns L&M
Not sure I fully understand your explanation but have a look and see if this is what you're after.
https://docs.google.com/spreadsheets...it?usp=sharing
solved! thank you!
Last edited by michlam; 05-29-2021 at 03:18 PM.
MaybeFormula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks