I need an excel guru to see if they can figure this out:.
I have table 1 and table 2
Column A in both tables are vendor numbers
Column B in both tables are invoice numbers
I need a formula to compare column A of both tables. If it find a match within the column, then I want it to compare column B.
If it finds a match for both then it needs to produce something like true, false, whatever.
But I need both columns to match, not just if column A matches column A but not column B. If vendor number matches from one table column to the other table column, then I need to know if the invoice number matches in both columns. If both tables have that data I need a "yes". If one table is missing the data I need a "no".
Super simple example:
Table 1:
Column A: Column B: Column C:
Vendor #. Invoice #. Data Match
112. 05871. NO
111. 25034. YES
Table 2:
Column A: Column B:
Vendor #. Invoice #
111. 25034
112. 87150
The ideal formula will insert answer into Column C in table 1
Does this make sense? What formula can I use? (V-lookup is great except I’m only comparing one column of data... I need in the case of 2 columns)...
Bookmarks