To find data

  • Thread starter Thread starter rocketron
  • Start date Start date
R

rocketron

I need someone to help me. I don't know whether it would be easier to put
data from one sheet into another first and then find matches with this list
in the data of another.
I need to searcxh for items anhd then copy all the data that is adjacent to
the matched numbers to create a list for someone else to work with.

Can anyone tell me how to go about this. I think I should have started
earlier on learning spreadsheets!
 
If you already have a list of known items you want to find, use this with a
VLOOKUP to match to the corresponding value in your master table. You can
also use an IF statement to mark everything that matches with a convenient
marker and then sort by this to collapse the matched data to pass on
 
Back
Top