Excel Course - Lesson 5

Discussion in 'Simplilearn Support' started by Waleed Saleem, Feb 10, 2019.

  1. Waleed Saleem

    Waleed Saleem Member

    Joined:
    Feb 1, 2019
    Messages:
    2
    Likes Received:
    0
    Hi,

    I am confused about the offset function.

    During lesson 5 for the combobox exercise we used =offset($B$6,row()-6,$Q$1)

    and for the scroll bar we used =offset($B$6,row()-15,$A$15).

    What I don't understand is why did we use -6 in one instance and -15 in another? How do we what to put next to the row so that it returns the first or second row value in the table?

    Thanks!
     
    #1
  2. Shohini_1

    Shohini_1 Well-Known Member
    Simplilearn Support

    Joined:
    Sep 24, 2018
    Messages:
    84
    Likes Received:
    4
    Hi,

    Could you please share the topic name that would really help us to guide you accurately?
     
    #2

Share This Page