How can I make a unit price populate in a spreadsheet based on a string in another column?

by on March 24, 2010

Q: I am working on a quote worksheet in Microsoft Excel. I would like to be able to have my unit price automatically populate in column E based upon the string value I put into column B using Excel in Office 2003. How would I get this to work?