How do I compare two tables by article?
There are two Google tables, with different number of rows and different sorting in each table there is a column "Article". You need to extract only those lines that match the Article and present them in this form for price comparison:
0
1 answers
In the first table in D3 and stretch below:
=IFERROR(VLOOKUP(D3;$F$3:$H;3;);)
Prices from the second table will be pulled up.
Next-filter by values >0, copy the visible ones to a separate range
0
Author: vikttur, 2020-03-26 10:50:04