Hi smithrv. Here's how I'd do it:
First, turn your lookup table into an Excel table. I use the keyboard shortcut Ctrl + T to do this.
Then in say cell C6 put "Number of matches"
Then in say cell C7 enter this formula:
=COUNTIFS(Table1[OD],B2,Table1[ID],B3)
By the way, calculation is set to manual in your file. I never do this...it's too risky.
Many people mistakenly think that having to run a spreadsheet in manual calculation mode is simply a byproduct of having a big spreadsheet with lots of data and formulas in it. But in actual fact in most cases I've seen, performance issues are more often than not because of inefficient spreadsheet design – compounded by so-called volatile functions such as OFFSET, INDIRECT, TODAY, NOW, and RAND – rather than simply being a by-product of big files.
Bookmarks