View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

If it is really that simple then in cell b1
=if(a1="pleat",105,"")
or if you have a lot of this take a look in HELP index for VLOOKUP


--
Don Guillett
SalesAid Software

"chet" wrote in message
...
How do I link a number to a word? ie If I type "Pleat" in cell A1 it will
show "105" in cell B1? Is this possible?