Excel Forum
Similar Content
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...
Vlookup on Dates and Times in Excel
Tutorial: Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of l...
Format Cells as an Accounting Number in Excel Number Formatting
Macro: This free Excel macro formats a selected cell as an Accounting number. This means that the...

Excel Magic Trick 607: Match 3 Lists: Matching Accounting Documents PO, Receiving & Invoice

See how to Match three lists using 2 VLOOKUP functions and the AND function. Matching the accounting documents PO, Receiving documents and the Invoice.

Is item in list? Compare two three tables.

Got a Question? Ask it Here in the Forum.