Thread: format cell to know number of another cell automatically
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary L Brown
 
Posts: n/a
Default format cell to know number of another cell automatically
Use the vLookup() function.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Dee" wrote:

If you have a spread sheet and you have multiple cells that have the same
numbers, i.e if cell A3= 15.90 cell B3 is always going to be 18.30. If I
type 15.90 into any other cell A is there anyway to format the sheet to
know that cell B will auto fill with 18.30?
Reply With QuoteReply With Quote