Results 1 to 2 of 2

Thread: Offset Function based on drop down validation menu

  1. #1

    Offset Function based on drop down validation menu



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    Can someone assist me with the attached spreadsheet? I am having trouble using the offset function. It only works for TO 2 and TO 3. I'm not sure why I am receiving an error message. Thanks! CLIN Template OffetSet.xlsx

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    THe problem is the $A$2:$A$8 bit: you need to expand it to cover TO6. i.e. from MATCH($D$5,'Value History'!$A$2:$A$8,0) to MATCH($D$5,'Value History'!$A$2:$A$15,0)

Posting Permissions

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