Alternative to multiple IF statements

[CaptainGravyBum]

Hello,
I have a spreadsheet where I have been using multiple if statements to return a value in one of the columns. The problem is that the data I'm using has changed somewhat, so now there are around 50 different results to query.
As an example: =IF('Sheet1'!G2="1D","ND",IF('Sheet1'!G2="2D","EC",IF('Sheet1'!G2="3D","EC"))) and it goes on.
This is only three IF's but it's getting to be a bit silly now I have to go up to 50 of these (I'm not even sure if there's a limit).
I'm willing to accept this is probably the worst way to get the information I need.
Any suggestions welcome.

 

[awoohaw]

You can do this with a lookup function. Put a reference table in an unused portion of your workbook. In one column put your lookup values, and the other column your values to return. There are other ways as well. I'm sure folks will post their methods also.

 

[CaptainGravyBum]

You can do this with a lookup function. Put a reference table in an unused portion of your workbook. In one column put your lookup values, and the other column your values to return. There are other ways as well. I'm sure folks will post their methods also.

Hi @awoohaw,
This answer was staring me in the face and I couldn't see it, I've been looking at this problem too long.
Thanks for your help.

 

[awoohaw]

Stepping away or asking for another person's viewpoint is how many problems are solved. It happens to me frequently.
Happy to help.

Best Wishes!