Number verification across sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1829408%22%20slang%3D%22en-US%22%3ENumber%20verification%20across%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1829408%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20this%20may%20be%20similar%20to%20a%20different%20question%20I%20have%20asked%2C%20however%20I%20think%20the%20requirement%20is%20slightly%20different.%20If%20not%20apologies.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20sheet%201%20called%20%22Requirements%22%20and%20sheet%202%20called%20%22DODICS%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20C2%20sheet%201%20to%20reference%20a%20value%20in%20A2%20sheet%201%20against%20column%20A%20in%20sheet%202.%20If%20the%20value%20matches%20then%20populate%20sheet%201%20C2%20with%20the%20value%20in%20sheet%202%20one%20cell%20to%20the%20right.%20If%20there%20is%20no%20value%20to%20match%20then%20display%20N%2FA.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1829408%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1829563%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20verification%20across%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1829563%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F824194%22%20target%3D%22_blank%22%3E%40rrbailey%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20C2%20on%20Requirements%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DVLOOKUP(A2%2C%20DODICS!%24A%3A%24A%2C%202%2C%20FALSE)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20can%20be%20filled%20down%20if%20required.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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
Highlighted

@rrbailey 

In C2 on Requirements:

 

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

 

This can be filled down if required.