Forum Discussion

DazPitts's avatar
DazPitts
Copper Contributor
Aug 27, 2023

Match Function Help

Hello, 

 

I am having trouble understanding the Match function and I need assistance if possible. Briefly, I manage 700 personnel, and I have a roster that I have to resort every week in order to depict all personnel new and old, according to their company (A, B, C, G Co, and HQ) with respect to their security clearance level. The fields I am trying to match are "subject name, or SSN, with UIC (Company Code).

Please walk me through this process if possible, it will save me about 5 hours within my work week.

excel
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 27, 2023

    DazPitts 

    Please provide detailed and specific information about your setup. If possible, could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources