Thread: Compare Cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Peter is offline
external usenet poster
 
Posts: 349
Default Compare Cell

Hi, I am trying to compare a cell that contains text located at "m87" with a
list of place names, ie Brisbane, Sydney, Melbourne.

Each city has numbers to go with it, so if the cell contains say Brisbane,
then it would input 30 into cell "n88". The same for the rest with diffrent
numbers of course.

I searched the forums for something similar, but no luck.

Any help appreciated.
Peter