Choose data from a particular column based on a specific value
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 |
markx wrote:
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 |
All times are GMT +1. The time now is 03:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com