How to auto-copy column between sheets, based on a cell value

[lalakis]

Guys, please help! I've been trying to do this for the last 5 hours!

I have an excel 2010 file with two sheets. Sheet 1 has some functions that make calculations like this: Column A is the "input" data, and all other columns make calculations based on column A data. Sheet 2 has some sample data in columns, which i am currently manually copy-pasting to Sheet 1 column A in order for sheet 1 to make the calculations. So every time i want to change the set of data, i have to copy-paste a column from sheet 2 to sheet 1- column A.

What i want to do:

I want to have a specific cell in sheet 1 that will act like this when i manually enter values to it:

If entered value in that cell = A, then copy sheet2columnA to Sheet1columnA
If entered value in that cell = B, then copy sheet2columnB to Sheet1columnA
If entered value in that cell = C, then copy sheet2columnC to Sheet1columnA (notice that the destination is always the same, but the origin of data is based on my input)
etc... so that i just manually enter A, B or C to that specific cell, and it automatically changes the values in Sheet 1 Column 1 by taking data from the sheet 2 column that refers to my input.

If you can tell me how to do this, you have both my warm thank you and my respect.
Thank you in advance

[Ken Puls]

Assuming your cell that you're driving it from is B2, and the data you're after is in row 2 of Sheet 1, then this should work:

=IF($B$2="A",Sheet2!B4,IF($B$2="B",Sheet2!C4,Sheet2!C4))

Copy that down and you'll get the rows below to come over as well.

[lalakis]

Wonderful! thank you!