I have a list of about 200 rows with different 3 letter codes. There are about 150 different codes. How can I get Excel to:
If B1=TEB then return "Teterboro, NJ" in cell D1.
If B1=LGA then return "New York, NY" in cell D1.
So forth and so on for all 150 different code posibilities.
I will be entering the data in column B, but need Excel to return the answer in D.
How do I or can I do this?? Thank you so much in advance.
If B1=TEB then return "Teterboro, NJ" in cell D1.
If B1=LGA then return "New York, NY" in cell D1.
So forth and so on for all 150 different code posibilities.
I will be entering the data in column B, but need Excel to return the answer in D.
How do I or can I do this?? Thank you so much in advance.