How to filter 2 tables by column with sku?

R

rfddddddd2021-03-01 14:52:05

excel

rfddddddd, 2021-03-01 14:52:05

I don't really rummage in excel, I tried to google - I did not find the desired result.
There are 2 tables. (one smaller with 3000+ sku, the second with 60000 sku and additional columns with information)
It is necessary to find sku from the first in the second table and filter them separately.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

B

BasiC2k, 2021-03-01
@rfddddddd

Read about the VLOOKUP formula
. This is the solution to your question.

A

Alexander, 2021-03-01
@ForestAndGarden

VLOOKUP(), copy-paste, sorting, copy-paste.