Formula for taking Info from same row dif Columns to make a list

**marcoantonio4311** · 09-26-2012, 09:26 PM

Hi, I am new and need some help. Hope I can explain it well enough. I am attaching the work sheet to make it easier to understand. I need to take info from the same row, yet different columns, and turn it into a verticle list on another part of the same workbook. in my example that I attach, the yellow highlighted part of the row is what I am turning into a list. The "components" section of my lunch menu builder workbook and turn the components into a verticle list. I hope I didnt confuse anyone. I need help Fast.Thank you for any help anyone can give.

**FDibbins** · 09-26-2012, 10:18 PM

try this in GA4, copied down...

=INDEX($B$3:$X$103,MATCH($AB$3,$D$3:$D$103,0),3+ROW(AB1))

for the other tables, copy that across and change $AB$3 to, for instance, $AG$3

let me know how you make out?

**marcoantonio4311** · 09-27-2012, 10:52 AM

thanks, that didnt work. Let me be more specific. I need to take all the info from E4:X4 and put it into a list on AC4:AC23. Thats all I need the Formula to do. and then be able to copy that formula to the other "components" list so that E5:X5 goes to AH4:AH23, and info in E6:X6 goes to AM4:AM23.....etc If anyone can help with this it will be a great help, thanks.

**marcoantonio4311** · 09-27-2012, 07:51 PM

Originally Posted by FDibbins

try this in GA4, copied down...

=INDEX($B$3:$X$103,MATCH($AB$3,$D$3:$D$103,0),3+ROW(AB1))

for the other tables, copy that across and change $AB$3 to, for instance, $AG$3

let me know how you make out?

Can you please look at what I reposted this morning? I really need some help

**FDibbins** · 09-28-2012, 08:54 PM

i tested it again in your sheet, ane it worked ok for me.

see the attached, i have put the formula in the top cell of each itime type, copy them down and see if this is what you want?