Tricky Array Tables

[bentor]

Hello everyone,

I have tricky array tables problem, which you can find in this file:
http://www.4shared.com/document/ggJVNhe2/ArrayTable.html

Case is to get matching data from sheet2 to sheet1 (into green cells)
without using a Macro.

I'm trying to use array table to get data from other table. It's seems
to not very complicated, but it's tricky. Does anyone has an idea how
to solve this?

Best regards,
BD.

 

[Don Guillett]

I looked at your file and you do not fully explain what you want but you
should be able to do easily with vlookup or match/index formulas.

 

[John]

Hi Bentor
Try this link, it's your file with the formulas :
http://www.mediafire.com/file/1dzzoyiioiz/Calendar.xlm
I think this is what you want.
HTH
John

 

[John]

Sorry wrong file, will post back.
john

Hi Bentor
Try this link, it's your file with the formulas :
http://www.mediafire.com/file/1dzzoyiioiz/Calendar.xlm
I think this is what you want.
HTH
John

 

[John]

Try this one http://cjoint.com/?eiwd6bL4qz
Sorry about that.
John

 

[bentor]

Hello,

Thank you for advice, but what you did is working in this case, but I
would like to make this sheet more flexible. That means that I will
have more brands and more indicators.
Any other ideas?

Best regards,
BD