Help with Nested IF function

[Pariah81]

I'm hoping someone can help me.

I have a 100 inputs and 100 outputs

I populate column A with inputs and column B with outputs.

Column C will contain data that will match to one cell in column A

I want Column D to populate with the corresponding output from Column B.

Is there an easy way to do this?

 

[AhoyNC]

Try using VLOOKUP

Excel Workbook
	A	B	C	D
1	Input	Output
2	Test1	out6	test4	out9
3	Test2	out7
4	Test3	out8
5	Test4	out9
6	Test5	out10
7	Test6	out11
8	Test7	out12
Sheet

 

[Pariah81]

Thanks!

 

[AhoyNC]

You're welcome. Thanks for the feedback.