What you need is not an If formula, but rather a vlookup function.
Have a look at the following vlookup video tutorials:

http://www.free-training-tutorial.co...n-vlookup.html



"honey do repairs" wrote:

I am trying to set up a spreadsheet where I can create an invoice. I want to
be able to have a price list in another area of the spreadsheet; enter a code
and have the unit price displayed in the invoice area.

I am not proficient in excel. just know the basics. HELP!