MS Excel IF or VLookup

Not certain if this falls within an IF, VLookup or other function...
I have a column that will contain one of four different values: EE, ES, FA, WA

When one of the four codes is present I need to display an associated number in an adjacent cell/column (on that row).
EE=82.15
ES=180.75
FA=225.93
WA=0.00

Looking for the best way to accomplish this.
LVL 9
Lee IngallsDirector of IT/TS, Quality and FinanceAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

byundtMechanical EngineerCommented:
I would put your values in a lookup table and use a VLOOKUP like:
=VLOOKUP(A2,LookupTable,2,FALSE)
Saqib Husain, SyedEngineerCommented:
=VLOOKUP(A1,{"EE",82.15;"ES",180.75;"FA",225.93;"WA",0},2,0)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
byundtMechanical EngineerCommented:
If you might have a different value in cell A2 than one of the four choices, I suggest using IFERROR around the VLOOKUP as shown in the attached file:
=IFERROR(VLOOKUP(A2,LookupTable,2,FALSE),"")
LookupTableQ28329283.xlsx
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

Lee IngallsDirector of IT/TS, Quality and FinanceAuthor Commented:
Thank you. Both byundt's and your solutions looked similar in that they suggested VLookup; however Syed's more straight forward to implement. Thank you both for your suggestions.
Lee IngallsDirector of IT/TS, Quality and FinanceAuthor Commented:
I just requested an update to "accept multiple answers" since I also incorporated byundt's IFERROR suggestion into my final solution.
Lee IngallsDirector of IT/TS, Quality and FinanceAuthor Commented:
Thank you both for your knowledge and assistance.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.