blocking 2 cells together (name and number)

[array41]

Hi,

I have a question. I am currently making a database.The thing is I have 2 tables : one with all the information and the other one is the resume for the graph. Moreover I have used the array programme for this table so that all my data are now ordered from the largest to the smallest.

I would like to block the cell of this last table so that each time the numbers change, the name in relation with this number will change too.
With the array, the result will change from place depending on the evolution of our market. That s why I would need to block this 2 cells.

I know that my explanations are a little bit complicated but first english is not my mother language and secondly I can't even find the right word in my mother language.

Can you please help me?

 

[Smitty]

Welcome to the Board!

You might want to post in the International Forum (Questions in other languages).

Barring that can you post a shot of what you've got and what you want as a result? Take a look under my sig line for the link to Colo's HTML Maker which will let you do that.

Smitty

 

[array41]

please can someone help me

I posted my questions yesterday and didn't get any answer that could help me

 

[Smitty]

You didn't give any more detail as to what you need.

If by blocking two cells you're trying to join them you might be looking at concatenation, which you can do like this:

=A1&B1

Hope that helps,

Smitty

 

[array41]

Here is another explanation maybe it will help...
I have created a table so that every changes or evolutions of values will be automatic (using array to sort it out from the largest to the smallest values).
Each value correspond to a name. the problem is if the value is changing and so changing from cell ( because of array) the name is not following the value. That mean that all the result is totally false.

 

[Smitty]

Take a look at INDIRECT in the helpfile.

Smitty

 

[array41]

found it

ok I found it by using HLOOKUP formulas

thanks

bye