Hi Lyndon,

In the Financial Reporter, you can see the list of the field names from the View menu and Account Data. They are organized by the type of data being returned. ACCT is the Account Number.

You can use File / Sent To Sheet / Account Data to create a list of these field names (symbols) in a sheet you can print or export to Excel.

You can open the sample 'SuperSpec90' to see what data value any given field name will return, plus a description of what each field code represents.

In your specific formula example, the first account number in the range defined in cell B9 is returned if the value in cell A9 is not a range.