Hello,
I've been trying to write a formula to return an ID based on two criteria: 1. a unique premises ID, and 2. category type. The data sits on one sheet, the return info on another.
It looks like this:
DATA (In Table2):
<tbody>
PIN
PINStatus
PINTYPE
PREMISESID
01
Revoked
PON
123
02...