Previous Topic Next Topic

Matching data from two spreadsheets

Closed
jphorn Posts 1 Registration date Wednesday 6 November 2013 Status Member Last seen 6 November 2013 - 6 Nov 2013 à 18:02
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 7 Nov 2013 à 23:22
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

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
7 Nov 2013 à 23:22
try match function. if problem post small extract of data and explain again.

Similar discussions

Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses