Hello, this may be similar to a different question I have asked, however I think the requirement is slightly different. If not apologies.
I have sheet 1 called "Requirements" and sheet 2 called "DODICS".
I need C2 sheet 1 to reference a value in A2 sheet 1 against column A in sheet 2. If the value matches then populate sheet 1 C2 with the value in sheet 2 one cell to the right. If there is no value to match then display N/A.