Hi Jason,

Am Thu, 2 Oct 2014 08:49:47 +0100 schrieb JasonL:

I want to avoid this if possible. The above was an example, I have way
more than 5 columns. Company order is somewhat random, so I don't want
to have to find each column that relates to each company and manually
insert that in the formula at the top of each column. I want this to be
an automated process if possible, the above way I'd have to be manually
adjusting the formulas as I fill out the master sheet every time I run
pays depending on which company it is for.

for both companies in A1:
=INDEX(Master!A:A,ROW())
For "ABX in B1:
=IFERROR(INDEX(Master!$A$1:$F$2000,ROW(),SMALL(IF( Master!$1:$1="AXB",COLUMN($1:$1)),COLUMN(A1))),"")
enter the array formula with CTRL+Shift+Enter and copy to the right and
down.
Same formula with "ATA" for the other company


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional