Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    add to a index formula (2000)

    Hi you guys have help me with the attachment now they added a drop down in H if someone picks new from the drop down is there a way that in F instead of it say which row could it say in new location or even just be blank
    I'm so glad you guys are out there I know I would have been out the door by now
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: add to a index formula (2000)

    If you want the cell in F to read "New Location":
    <code>
    =IF(H3="New","New Location",INDEX(Sheet2!$B$2:$B$14,MATCH(E3,Sheet2! $C$2:$C$14)))
    </code>
    or if you want it to be blank:
    <code>
    =IF(H3="New","",INDEX(Sheet2!$B$2:$B$14,MATCH(E3,S heet2!$C$2:$C$14)))
    </code>
    This is for F3; fill down as far as needed.

Posting Permissions

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