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

@rrbailey 

In C2 on Requirements:

 

=VLOOKUP(A2, DODICS!$A:$B, 2, FALSE)

 

This can be filled down if required.