Number verification across sheets

Occasional Contributor

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!

1 Reply


In C2 on Requirements:




This can be filled down if required.