If I could please get some help, many I work with will also be thankful!
Here's the situation:

--spreadsheet A, workbook 1 (thousands of rows):
Col.A--00 through 20
Col.B--Acct. No.
Col.C--Title
Col.D--Balance

--spreadsheet B, workbook 2:
I want to search spreadsheet A, Col.A with a value of 01 and Col.D
with a balance not equal to $0. If Col.A's value is 01 and Col.D is not
zero, return the data for that row for all 4 columns.

--spreadsheet C, workbook 3:
Same as above except Col.A = 02.

--etc., etc...

Grazie!!!



--
MVD
San Francisco, California