Thread: Need to display a number when a specific text is entered
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Desperate Desperate is offline
external usenet poster
  
Posts: 20
Default Need to display a number when a specific text is entered
I have 4 different text options that I enter in column A. I need a
corresponding price to automatically display in column C. For example:
EE = 4.74
ES = 9.68
EC = 9.58
FAM = 13.78
I need to enter these same text options in 3 separate columns and have a
different price assigned.
What formula do I use? How should it be written? Please help, I've been goin
craZ with this all day!
Reply With QuoteReply With Quote