Find Unique cell then copy to other sheets

Here is an Example of what I like to do.

Take each individual cell from Missing Sheet under columm Missing Equipment and look them up on the Inventory Scan Sheet under all columms & rows, if Result is a match and they are found on any cell then copy and paste the found cells contents to the Result Sheet under columm Match and Found, if not found then copy paste the remaining not found cells contents from the Missing Sheet to the Result Sheet under columm Missing Not Found

!!!!!!!!!HOPE I AM MAKING SENCE HERE!!!!!!!!!!!!!!!!

Thanks a million.........