if criteria extract group of numbers

**zzz444** · 06-13-2020, 04:44 PM

hello to everybody,i have attached a file which shows a box from D5 to L5 at which i will put manually and randomly the numbers 1-9 ,at the A:A column i show the group numbers of each of the nine numbers,what i need is to extract those numbers at the line D9 to AM9 in the same order like in the yellow box.i showed an example in the attached file :so if D5 is 7 extract at Dto G9 the numbers which represent the 7 and so on ..i hope you can give me ahelp.yhanks

**zzz444** · 06-13-2020, 05:01 PM

=IFERROR(IF($D$5=1;CHOOSE(COLUMNS($CQ:CQ);14;31;9;22);IF($D$5=2;CHOOSE(COLUMNS($CQ:CQ);14;31;9;22);IF($D$5=3;CHOOSE(COLUMNS($CQ:CQ);14;31;9;22);IF($D$5=3;CHOOSE(COLUMNS($CQ:CQ);14;31;9;22);IF($D$5=4;CHOOSE(COLUMNS($CQ:CQ);14;31;9;22);IF($D$5=5;CHOOSE(COLUMNS($CQ:CQ);14;31;9;22);IF($D$5=6;CHOOSE(COLUMNS($CQ:CQ);14;31;9;22);IF($D$5=7;CHOOSE(COLUMNS($CQ:CQ);14;31;9;22);IF($D$5=8;CHOOSE(COLUMNS($CQ:CQ);14;31;9;22);IF($D$5=9;CHOOSE(COLUMNS($CQ:CQ);14;31;9;22);"")))))))));"")
why these formula is wrong?something with nesting

**zzz444** · 06-13-2020, 05:26 PM

=IF(D$5=1;INDEX(A$14:A$17;ROWS($11:11);D$5);IF(D$5=2;INDEX(A$14:A$17;ROWS($11:11);D$5);IF(D$5=3;INDEX(A$14:A$17;ROWS($11:11);D$5);IF(D$5=4;INDEX(A$14:A$17;ROWS($11:11);D$5);IF(D$5=5;INDEX(A$14:A$17;ROWS($11:11);D$5);IF(D$5=6;INDEX(A$14:A$17;ROWS($11:11);D$5);IF(D$5=7;INDEX(A$14:A$17;ROWS($11:11);D$5);IF(D$5=8;INDEX(A$14:A$17;ROWS($11:11);D$5);IF(D$5=9;INDEX(A$14:A$17;ROWS($11:11);D$5);""))))))))) ok i thing i made it

**oeldere** · 06-13-2020, 06:28 PM

I made a vlookup table in $A$19:$E$27.

After that (see the green cells)

D13 =VLOOKUP(INDIRECT(ADDRESS(5,3+ROUNDDOWN((COLUMN()/4),0))),$A$19:$E$27,2+MOD(COLUMN(),4),0) and drag to the right.

See the attached file.

**zzz444** · 06-14-2020, 02:21 AM

thanks,super!

**oeldere** · 06-14-2020, 03:27 AM

@zzz444

Invalid Attachment specified. If you followed a valid link, please notify the administrator.

Thanks for the rep.

Glad I could help.

If you are satisfied with the solution, please mark the question solved.

if criteria extract group of numbers

LinkBack

Thread Tools

Rate This Thread

Display

if criteria extract group of numbers

Re: if criteria extract group of numbers

Re: if criteria extract group of numbers

Re: if criteria extract group of numbers

Re: if criteria extract group of numbers

Re: if criteria extract group of numbers

Thread Information

Users Browsing this Thread

Similar Threads

a formula to evaluates how many numbers in a group of 5 numbers are part of a lot of nbrs

If a combination extract a group of numbers

[SOLVED] Macro to generate groups randomly of 20 numbers, being 10 of group A and 10 of group B,

[SOLVED] Extract the minimum and second lowest numbers from an array with multiple criteria

Extract a list of numbers under multiple criteria to another workbook

[SOLVED] How can I convert a group of numbers to a group of letters?

[SOLVED] Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?

Bookmarks

Bookmarks

Posting Permissions