Trying to find a formula, I was told a vlookup would work best I'll try to describe this as well as possible.
Two excel files.
Excel sheet 1 has the PID in column K. Excel sheet 2 has the PID in column C and the computer name in column A.
I need the PID numbers of sheet 1 and 2 to match any identical ID numbers and if the ID numbers match, I need it to grab information only information from column A (computer name) on sheet 2 and place it on column A of sheet 1.
Sorry if this is confusing, ask if you need clarification.