Formula to either pull multiple values with an Hlookup or a substitute formula instead of an Hlookup

Hello everyone,   I am trying to either update my hlookup, or come up with a different formula when pulling values.   My file includes a tab that has all my general ledger accounts in one row and...