Matching data from two spreadsheets

Closed
jphorn Posts 1 Registration date Wednesday November 6, 2013 Status Member Last seen November 6, 2013 - Nov 6, 2013 at 06:02 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 7, 2013 at 11:22 PM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 7, 2013 at 11:22 PM
try match function. if problem post small extract of data and explain again.
0