Matching data from two spreadsheets

[Closed]
Report
Posts
1
Registration date
Wednesday November 6, 2013
Status
Member
Last seen
November 6, 2013
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
I have 2 spreadwheets. One is a master equipment list with info stored according to Equipment #.
The second is an invoice for equipment that is on the master list.
I need to find the record (row) on the master list that matches the invoice equipment# and then IF there is no date in the "observed" column then put that whole row on a 3rd spreadsheet.
Any help is appreciated.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
try match function. if problem post small extract of data and explain again.