Hi
I have 1 table with date in column A and and 3 digit code in column B. The 3 digit codes appear once each date. Columns C-H have the data which I want to fill cells in several other tables (each one for a diferent 3 digit code), set out by date.
My aim if to create a formula which will go and get the data in C-H if A="date" and b="3 digit code" I have tried diferent combinations of match, Index, and Vlookup but cannot seem to get the data I want to fill the cells.
I would also be interested in any macro solutions that would do the trick.
cheers
I have 1 table with date in column A and and 3 digit code in column B. The 3 digit codes appear once each date. Columns C-H have the data which I want to fill cells in several other tables (each one for a diferent 3 digit code), set out by date.
My aim if to create a formula which will go and get the data in C-H if A="date" and b="3 digit code" I have tried diferent combinations of match, Index, and Vlookup but cannot seem to get the data I want to fill the cells.
I would also be interested in any macro solutions that would do the trick.
cheers