Pick up values from a table based on 1 condition

[batchjb69]

Hi

How do I get all accounts in the name of James on the feeder sheet into cells from A6. Using a formula

You would end up with

A6 - 1222
A7 - 4785
A8 - 1588



excel help.xlsx

[FDibbins]

Hi and welcome to the forum

Try this little trick.

on FEEDER in D4, copied down...
=COUNTIF($A$4:A4,'Main sheet'!$A$3)
Then use this, copied down and across on MAIN, A6...
=IFERROR(INDEX('Feeder sheet'!$A$3:$C$16,MATCH(ROW(A1),'Feeder sheet'!$D$3:$D$16,0),MATCH('Main sheet'!A$5,'Feeder sheet'!$A$3:$C$3,0)),"")

[batchjb69]

Hi

Many thanks for this nifty formula. I should have said this is a snapshot of a huge spread sheet. Which has about 50 portfolio managers on it. Can you think of a simpler way of doing this.

Ultimately on the main spread sheet there would be 50 tables. One for each PM

James

[FDibbins]

Can you upload a sample that more closely matches your layout/format/data then please

[batchjb69]

Hi for some reason my upload does no work.

Basically on the original you would have the same layout as rows 3 and 5 but with a different PM name. for example say cell A11 would be Dave Cell A 20 would be Sarah etc with all their accounts shown underneath.

[batchjb69]

excel help.xlsx

Please see updated spreadsheet

[FDibbins]

I created a quick pivot table, see if this is something you can work with?