Forum Discussion
Linking data based on criteria
Hi Hope someone can help.....I have 2 sheets. I want to link the data from Sheet1 to Sheet2. But..... I only want to link it if it meets criteria in Sheet1!B2 (Status column). I only want lines ...
There is no need for a second sheet. Filter the table itself.
Otherwise use FILTER() or a pivot table.