I'm working on utility data for a chain of stores. I need to lookup an
account number based on both facility # and meter # b/c some facilities have
multiple meters.

This formula only matches the account # and does not cross reference meter #.
=VLOOKUP(A96,Gaps!$A$8:$D$2102,3)

A96 = fac # on sheet 2
Gaps!A8:D2102 = where data is kept
On gaps page, fac # is column A, account # is column C, meter # is column D

Thanks in advance for any words of wisdom!