I tried formulas and macros to populate sheet2 from sheet1 based on criteria. I need the row from sheet1 to populate sheet2 based on data in sheet1 C2:C1500. My expected results are on Sheet ‘Body!’
I tried formulas and macros to populate sheet2 from sheet1 based on criteria. I need the row from sheet1 to populate sheet2 based on data in sheet1 C2:C1500. My expected results are on Sheet ‘Body!’
The departmental numbers are stored as TEXT rather than as numbers, hence the " " round the "numbers" in this formula. Place in A2, copy across and down:
=IFERROR(INDEX(Plant!A:A,AGGREGATE(15,6,ROW(Plant!$A$2:$A$948)/(Plant!$C$2:$C$948={"11","44"}),ROWS($1:1))),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I missed your 3rd "OR" criterion:
=IFERROR(INDEX(Plant!A:A,AGGREGATE(15,6,ROW(Plant!$A$2:$A$948)/(Plant!$C$2:$C$948={"11","44","19"}),ROWS($1:1))),"")
That is awesome. Works perfectly. Thanks Glenn.
No problem. you're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks