Home / Smart Hardware

Filter out the corresponding data from another table

time：2024-10-01 16:02:59 Smart Hardware

How do I filter out data that already exists in another table from one table?

1. Open a table and enter the targeting keywords you want to extract data from another table.

2. Switch to another table to see that there is complete data on the page.

3. Click "fx" in the cell where you need to extract data in the first table and insert the "vlookup" function, or directly enter the function formula: =VLOOKUP(A2,Sheet3!). A1:B6,2,0)。

4. Click Enter and drop down the formula to extract the data from the first table in the second table.

# Smart Hardware #

《Filter out the corresponding data from another table》 This does not represent the views of this website. If there is any infringement, please contact us to delete it.

Latest article

Recommend

Ranking

Digital Insights