help with a formula

[deskjet830c]

I need help with this formula to shorten it up
=(IF(A1=$E$1,f1))+(IF(A1=$E$2,f2))+(IF(A1=$E$3,f3))
I want to enter in cell A1 a description from a long list of items and then populate the correct price. The list is in Colum e and the price are in Colum F

Thank in Advance

[Pinexl]

It seems to me that a simple VLOOKUP should do the trick:
=VLOOKUP(A1,$E$1:$F$3,2,0)

Hope this helps!

[deskjet830c]

Thank You Pinexl that did the trick

[Pinexl]

You're welcome! Happy to help!

[AliGW]

Administrative Note:

Welcome to the forum.

For future reference, your thread title does not meet our expectations.

In future, make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

Thanks.