Hi all. I am trying to write a lookup formula that would be based on a range. This is based on a general ledger report. So I want all data that is associated with GL accounts 5000-5999 to appear on a separate analysis tab? Any thoughts how I can accomplish this? Thank You.