Results 1 to 3 of 3

Thread: Lookup (2003)

  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Edison, New Jersey, USA
    Posts
    215
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Lookup (2003)

    I want to take a value ('TC Scenario'!A5), go to another data sheet ('Dose chart'!) and find that value between cells B8:E8.

    Once I have located the associated column, I want to scan down the column and verify that the value in 'TC Scenario'!A8 exists. "true","error"

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Lookup (2003)

    If I understand correctly:

    =IF(ISNUMBER(MATCH('TC Scenario'!A8,INDEX('Dose chart'!B9:F100,0,MATCH('TC Scenario'!A5,'Dose chart'!B8:F8,0)),0)),"true","error")

    I presumed you wanted to look in rows 9:100 of Cols B:F for the value in A8. If not adjust the range as desired...

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Edison, New Jersey, USA
    Posts
    215
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Lookup (2003)

    THANK YOU! I tried for 2 hours (obviously unsuccessfully).
    It was PERFECT!

Posting Permissions

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