In Sheet 1, I have a list of document numbers (alphanumeric) in Column A, which have a corresponding title listed in Column B.
I need to compare another list of document numbers (alphanumeric), (lets say in Sheet 2) with (Column A Sheet 1), and if they match, returns the corresponding title value found in Sheet 1 Column B.
For the blank Column B data, = I need to return a value here that compares column A (Sheet 2) to column A (Sheet 1), and if it matches, returns the value from the cell adjacent to column A (Sheet 1).
I hope that makes sense. Is it possible? Could anyone give me a formula or macro I could edit that would achieve this?