IMPORT TO NEW TABLE FROM EXISTING TABLE BASED ON CELL VALUE

Question

Hi&nbsp;&nbsp;New in the community here. 🙂&nbsp;Looking for a solution for the following,&nbsp;&nbsp;The column "VælgLand" has a list of values.&nbsp;In another sheet there are a table, which i would like to import to the first mentioned sheet, based on the value of vælg land. I did get this "kind of" to work, but...&nbsp;I want to import the specific lines from this table, that has value equal to "VælgLand" in 1 of the columns: Land, Land2 or Land3.&nbsp;1. so if "VælgLand" is set to "Afghanistan" in Sheet 1&nbsp;2. Any of the rows in this tabe that has the value "Aghanistan" in eather Land, Land2, or Land3...&nbsp;Will be extracted from here...&nbsp;To here...&nbsp;Is this possible?&nbsp;Hope you can help 🙂 !&nbsp;

sergeibaklan · Answer

MLehm2502&nbsp;
Could you please clarify why data shall be taken from this 4th row

not form other ones, what are other criteria?
And on which Excel platform/version you are?
&nbsp;

mlehm2502 · Answer

SergeiBaklan&nbsp;&nbsp;It should import all rows, which has the value from VælgLand in 1 of these 3 columns.&nbsp;&nbsp;Lets say this table is a list of companies - and the columns "Land", "land2" and "land3" are the differencet contries they operate in.&nbsp;When i go the other sheet and choose lookup "afghanistan" i would like excel to import rows that has the value "afghanistan" in eather of the columns&nbsp;"Land", "land2" or "land3"&nbsp;Sorry for poor explanation.&nbsp;Also we work in Office 16&nbsp;SergeiBaklan&nbsp;

sergeibaklan · Answer

MLehm2502&nbsp;
If you have FILTER function you may return filtered data as
=FILTER(Table2,
  (Table2[land]=A2)+
  (Table2[land1]=A2)+
  (Table2[land2]=A2))

Forum Discussion

IMPORT TO NEW TABLE FROM EXISTING TABLE BASED ON CELL VALUE

3 Replies

Resources