How can I get columns to autofill based on a corresponding column

[Halo636]

Hello all,

Thanks for taking the time to help me with my problem, the help is greatly appreciated.

-----Problem-----

I have 2 sheets, the first shall have 3 columns, A B and C. The 2nd sheet shall have A and B. A and B of both sheets must always stay together, they cannot get mixed up.

I shall use 1.A/B/C and 2.A/B to explain now. I need 1.A and 1.B to always stay together, same for 2.A and 2.B. Now 1.B needs to search for itself in 2.A, if found it needs to place the corresponding 2.B into column 1.C.

Is this possible, and if so how?

-----Problem-----

I'm sorry for the poor explanation, and I'll try to help explain it again as best I can if anybody needs me to, again thank you for the help.

[Pauleyb]

Not sure how the 'cannot get mixed up' plays into the problem, but it seems important to you. Regardless, VLOOKUP should work. Without knowing your sheet names, I'm using your syntax. Should be something like this in 1.C:
=VLOOKUP(1.B, <range that includes all of 2.A and 2.B>, 2, FALSE)