Need to search in tables, found to exactly same lines in these two tables.
Between these two tables I have working VLookup search, but need to have condition "AND these columns are also equal on this searched line".
So, in this example I need to show only:
(cause 4|DDDD has no eqivalent in first table)
re-word question for request:
need to compare two tables and found same lines (it is two export tables). I have working Vlookup between these two tables (middle column). But I also need second condition write to this Vlookup example.
companyA | value1
companyA | value 2
second table (just switched two columns):
value 1 | companyD
value22 | companyA
value1 | companyA
Need to this information:
companyA | value1 -- because this line is same for both tables