Tricky Array Tables

  • Thread starter Thread starter bentor
  • Start date Start date
B

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.
 
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.
 
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
 
Back
Top