Forum Discussion
IMPORT TO NEW TABLE FROM EXISTING TABLE BASED ON CELL VALUE
Hi New in the community here. 🙂 Looking for a solution for the following, The column "VælgLand" has a list of values. In another sheet there are a table, which i would ...
It should import all rows, which has the value from VælgLand in 1 of these 3 columns.
Lets say this table is a list of companies - and the columns "Land", "land2" and "land3" are the differencet contries they operate in.
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 "Land", "land2" or "land3"
Sorry for poor explanation.
Also we work in Office 16
If you have FILTER function you may return filtered data as
=FILTER(Table2,
(Table2[land]=A2)+
(Table2[land1]=A2)+
(Table2[land2]=A2))