Thread: Formula???
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Ron is offline
external usenet poster
 
Posts: 250
Default Formula???

I have columns of Part Numbers for different applications. A lot of the
different apps. take the same part#. I need to be able to type in a
description and price for each one. How do I get it to let me put my info on
all of the cells with the same Part# without physically typing it in every
cell.
I.E. If a cell in column A says part# 1111 the corresponding cell in
column F needs to say $1.00 . If colmn A says part# 1112 the corresponding
cell in Column F needs $1.50 etc.
ANY help would be appreciated...Thanks
--
Ron