If Function Problem

[knightx555]

Hi, I apologise if this question is really simple/stupid, but i am a beginner at excel. So
I want to get a cell to display the value of another cell. and i am trying to do this with a range. Here is the formula:

=IF($D$1=CA,Data2!$D27,IF($D$1=CL,Data2!$D39,IF($D$1=NCL,Data2!$D55,IF($D$1=NCA,Data2!$D17,IF($D$1=E,Data2!$D66,"Error")))))

The values in Data2! are the ones that i am trying to display.
CA, CL, NCA, NCL, and E are my ranges.
D1 is a value in the ranges
D1 is a value that will constantly change.

But my formula gives a #Value! everytime and i am not sure what i am doing wrong.

Thank you to anyone who can help me with my problem.