LinkBack URL
About LinkBacks
Looking for a non-array formula to look into column B1 in sheet named Here and also sheet named Enter and populate column A (Names), column B (Status) and column C (Sales #) in sheet named Here. See sample file.
Thanks
Looking for a non-array formula to look into column B1 in sheet named Here and also sheet named Enter and populate column A (Names), column B (Status) and column C (Sales #) in sheet named Here. See sample file.
Thanks
in A4
Formula:
Please Login or Register to view this content.
change RED range
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
try these three non array formulas...
for status...=IFERROR(INDEX(Enter!$D$2:$D$34,AGGREGATE(15,6,ROW(Enter!$A$1:$A$34)/(Enter!$D$2:$D$34=Here!$B$1),ROWS($A$1:A1)),COLUMN()-(COLUMN()-1),1),"")
for names... =IFERROR(INDEX(Enter!$B$2:$B$34,AGGREGATE(15,6,ROW(Enter!$A$1:$A$34)/(Enter!$D$2:$D$34=Here!$B$1),ROWS($A$1:A1)),COLUMN()-(COLUMN()-1),1),"")
for sales #... =IFERROR(INDEX(Enter!$E$2:$E$34,AGGREGATE(15,6,ROW(Enter!$A$1:$A$34)/(Enter!$D$2:$D$34=Here!$B$1),ROWS($A$1:A1)),COLUMN()-(COLUMN()-1),1),"")
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Re: Extract values based on dropdown selection
my 3 cents with Power Query
Sam Capricci: Outstanding solution, Sam Capricci! Thanks for the rep.
JohnTopley: Excellent solution, JohnTopley! Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks