Thread: using if formula on page 2 to post answer on page 1
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
  
Posts: 1,311
Default using if formula on page 2 to post answer on page 1
Try this in B4 on Sheet1:

=IF(Sheet2!B6="AC",Sheet2!A6,"")

HTH,
Paul

--

"Vandy" wrote in message
...
Can I make it do this? If, on sheet 2, b6= the letters AC, take the name
in
a6 and post it in b4 on sheet 1? If so I need help with the formula.


Reply With QuoteReply With Quote