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:
=IFERROR(INDEX(Enter!$B$2:$B$1000,AGGREGATE(15,6,ROW($A$1:$A$1000)/(Enter!$D$2:$D$1000=$B$1),ROWS($1:1))),"")
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.
JohnTopley: Excellent solution, JohnTopley! Thanks for the rep.
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
Sam Capricci: Outstanding solution, Sam Capricci! Thanks for the rep.
Re: Extract values based on dropdown selection
my 3 cents with Power Query
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks