Hi
try the following array formula entered with CTRL+SHIFT+ENTER):
=INDEX(Gaps!$C$8:$C$2102,MATCH(1,(Gaps!$A$8:$A$210 2=A96)*(Gaps!$D$8:$D$2102=B96),0))

where B96 stores the searched meter#

--
Regards
Frank Kabel
Frankfurt, Germany
"LoriM" schrieb im Newsbeitrag
...
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!