Choose data from a particular column based on a specific value

[markx]

Hi guys,

I wonder if this one is possible...

I have a kind of summary tab with data labels in rows (A5, A6, ..., An) and
with country names in columns (C3, D3, ..., n3), f. ex. "Austria",
"Belgium", "Germany" etc...

What I would like now is to create an automatic report on another tab (same
worksheet), formated in the same way for all the countries and functionning
like this:

if i put "Austria" in the A1 cell (f. ex. from the drop-down list), than the
report will take the numbers from the "Austria" column from the original
tab... Then, if I change the country name in A1, the report will adapt
accordingly. So, the only variable would be the column number based on a
specific value somewhere in this column (3rd row in our exemple)

Is that feasible? Are there any easier ways to do this? If yes, how should I
proceed?

Thanks for your help on this...
Cheers,

Markx

 

[Eric]

Hi guys,

I wonder if this one is possible...

I have a kind of summary tab with data labels in rows (A5, A6, ..., An)
and with country names in columns (C3, D3, ..., n3), f. ex. "Austria",
"Belgium", "Germany" etc...

What I would like now is to create an automatic report on another tab
(same worksheet), formated in the same way for all the countries and
functionning like this:

if i put "Austria" in the A1 cell (f. ex. from the drop-down list), than
the report will take the numbers from the "Austria" column from the
original tab... Then, if I change the country name in A1, the report will
adapt accordingly. So, the only variable would be the column number based
on a specific value somewhere in this column (3rd row in our exemple)

Is that feasible? Are there any easier ways to do this? If yes, how should
I proceed?

Thanks for your help on this...
Cheers,

Markx

HLOOKUP or VLOOKUP probably can do that
Eric