Oct 28 2020 12:44 PM
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.
Thanks for any help!
Oct 28 2020 01:11 PM - edited Oct 28 2020 01:11 PM
In C2 on Requirements:
=VLOOKUP(A2, DODICS!$A:$B, 2, FALSE)
This can be filled down if required.