Thread: I want to set up a cell where 1=3 so when I insert 2 it will = 6
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
paul paul is offline
external usenet poster
  
Posts: 247
Default I want to set up a cell where 1=3 so when I insert 2 it will = 6
or you could have a table with your two numbers side by side and use a
lVlookup to retreive the corresponding number(s)

--
paul

remove nospam for email addy!



"Ciscokid" wrote:

I am setting up a Excel worksheet for accountibility and what to simplify it
by having one number in a column equal another number in the next cell. I am
using Excel 2003
Reply With QuoteReply With Quote