Highline Excel 2013 Class Video 05: Cell References: Relative, Absolute & Mixed (8 Examples)

Posts Tagged with…

Reader Comments

  1. Edward Brocklehurst

    Hi…. Ive been looking for a specific formula and has driven me crazy for a week now
    I need excel to look up a date from a tray of data, which is easy, my problem is, it needs to consider 2 columns (employee ID's and training program theyve attended)
    Thank u in advance

  2. ExcelIsFun

    Search for this title:

    VLOOKUP function Beginner to Advanced 26 Examples (Excel VLOOKUP WEEK Video #1)

    two solutions in this video. one at 34:40 and one at 38:50.

  3. 1CBAITY

    i have a question> WHY CANT YOU USE ABSOLUTE VALUE ON A NAMED TABLE…..THE TABLE NAME WILL COME UP BUT YOU CAN'T USE F4 TO MAKE IT ABSOLUTE…..BY THE WAY I LOVE YOUR CHANEL IT HAS TAUGHT ME ALOT….KEEP THE VIDS A COMMING!!!!

  4. ExcelIsFun

    I wish that F4 worked on table. Check out this video (it shows how to lock a table referecne):

    Highline Excel 2013 Class Video 08: Excel Table Formula Nomenclature / Structured References 22 Ex.

    at the 20:58 minute mark – it shows a trick for locking in a table…

    BTW, you are welcome for the videos!

  5. Alex Leijen

    Ok, great explanation. One question though, what if u have a table. We have the formula like [@[id]:[ID]] to lock the row for a formula.. The uestion is how do i do the same for a column.. [[ID]:@[ID]] does not work..
    Any ideas?

  6. 66koolkb

    so I keep trying to use this F4 shortcut to lock the cell, but all that does for my computer is give me options to change projector settings…can anyone please tell me what I am doing wrong?? It is quite tedious to manually add the $ sign in front every time. I have windows 7 and am working on a PC. Much help would be appreciated.

  7. Rishabh Mehta

    Thanks a lot, this is the first time m using excel. Before watching your vidoes i thought learning excel would a tough task for me, but u have pleasantly proven me wrong. I have never come across such a teacher who takes pain to make something complex appear fun to learn.
    Thanks once again.

  8. איגור שוויגר

    Hello, first of all thanks for your videos !
    I found some error in your calculations at sheet cr2 and cr2(ans), at cell k25 when you trying to show how to find the sell price your formula is not correct. You wrote =B8&" – "&B8&" * "&B2&" = "&B8-B18, and it's
    has to be =B8&" – "&B8&" * "&1-B2&" = "&B8-B18
    because 50-50*0.4≠20 and it's has to be 50-50(1-0.4)=20

  9. Tricia Donovan

    If I wanted to reference a cell in a table such as a title, not a cell, and lock it… How do I do that? I seem to only be able to use the F4 option with cells. I am specifically talking about when using SUMIFS or AVERAGEIFS statements.

  10. JAYESH SAROJ

    Sir i can see your effort..may god bless you always.l’m very new to excel but you teach in so detail which is making me learn how excel is thinking which will make me use my logics later.once again god bless you

Write a Comment

Your email address will not be published. Required fields are marked *