Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: If Statement

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Alabama USA
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Working with two sheets in same workbook.
    Sheet 1 data input
    Sheet 2 Report using data in Sheet 1

    Problem:

    If Col B3, sheet 1 = 20, I want the TEXT in B1, Sheet 1 to store in A2 of sheet 2.

    Any help will be greatly appreciated.



  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-08 07:05, wilcor wrote:
    Working with two sheets in same workbook.
    Sheet 1 data input
    Sheet 2 Report using data in Sheet 1

    Problem:

    If Col B3, sheet 1 = 20, I want the TEXT in B1, Sheet 1 to store in A2 of sheet 2.

    Any help will be greatly appreciated.


    Put this in A2 of Sheet 2

    =IF(Sheet1!B3=20,Sheet1!B1,"")

    I assume you want nothing if B3 in Sheet1 doesn't equal 20. If my assumption is wrong let me know.

    Regards,
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •