Excel Vlookup two conditions

Question

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:

1|A

5|E

7|G

(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.

first table:

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

Answer 1

Your post does specifically say worksheet formula, but I don't know Excel very well. However, as a work around (since you have had no answer yet), I offer you this VBa.

This should get you going. Please create a copy of the file first, as VBa does not have an undo option! Since you mention in your comments you understand some VBa I will hope the below is actually clear and easily editable to suit your needs!

Option Explicit
Sub DoTheThing()

Dim row As Integer
row = 2

Dim innerRow As Integer
innerRow = 2

Range("G:G").Clear


Do While Range("A" & row).Value <> ""

    Dim company As String
    Dim companyValue As String

    company = Range("A" & row).Value
    companyValue = Range("B" & row).Value

    Do While (Range("D" & innerRow).Value <> "")

        If Range("D" & innerRow).Value = companyValue And Range("E" & innerRow).Value = company Then
            Range("G" & row).Value = Range("G" & row).Value & "Matches row " & innerRow & ". "
            Range("G" & innerRow).Value = Range("G" & innerRow).Value & "Matches row " & row & ". "
            exit do ' THIS IS NOT TESTED
        End If
        innerRow = innerRow + 1
    Loop
innerRow = 2
row = row + 1
Loop

End Sub

Data looked like:

And after VBa runs: