Thread: how to autopopulate a cell using a formula
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Chris Bode[_21_] Chris Bode[_21_] is offline
external usenet poster
  
Posts: 1
Default how to autopopulate a cell using a formula

you can achieve this task using vlookup
in sheet2 enter data as
A1 B1
yellow Basic
green Primary
Now in sheet1, select A1 and enter formula
=VLOOKUP(B1,Sheet2!$A$1:$B$2,2,FALSE)

Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com




--
Chris Bode
Reply With QuoteReply With Quote