I am trying to write a macro in order to do the following:
In one workbook, I want to search for data from another workbook and return a value based on the ID # if certain criteria is met.
IE: If it says Melanie Jackson or Hector Hernandez in the October column, I want it to return this value...