# Video Lesson: Absolute & Relative Referencing

## Absolute and Relative Cell Referencing

Note: This video was originally the 3rd lesson in the plan, but due to the comments regarding it being too confusing at that level, I have moved it to the Intermediate section effective 3/23/17.

This video tutorial focuses on Absolute vs. Relative cell referencing within Excel.  You likely know it as the dollar sign (\$) used in functions/formulas (for example, C5 vs \$C\$5).

There is also a quick demonstration of the video using a VLOOKUP formula.  The VLOOKUP formula is explained in more detail in these two lessons here and here, but the example in this video gives a basic understanding of how it works in Excel.

Update 5-22: I’ve noticed some users (especially those with Macs) have had difficulty viewing this video.  Since it is one of the older videos, I will be re-recording it and adding information so that it is comparable to more recent videos.

If you’re following the Lesson Guide, next up is Math & Statistical Functions (e.g. SUM, AVERAGE)

## 57 thoughts on “Video Lesson: Absolute & Relative Referencing”

1. Thank you very much for these vídeos! Many people charge for this some thousands of dollars! The quality is good enough for those who are at least self learners. Congratulations!!

2. You totally lost me on this video.

• I have now moved this lesson to the ‘Intermediate’ section based on the above information about it being too confusing this early on in training.

3. Great video. For those who got value out of the Vlookup lesson, also research INDEX MATCH

4. Hi Ben,

Thank you for the videos. As a graduating college student, I feel so weak in excel. I don’t know much about it. The lessons have given me a nice look into it, and I feel good about following through your lessons! This will potentially land me a job in finance, which is what I am looking for. Thank you!!!
I am just a little curious, why are you giving free excel lessons?

5. Hi, thanks for your tutorials. I am an absolute beginner, and the first two were fantastic. This video, however, as the third in the suggested series, was like being thrown into the deep end not knowing how to swim. I didn’t have a point of reference from which to grasp the information, had no idea how this was applicable to anything (i.e. why you’d want to autofill the same numbers over and over with the \$ method), and the steps moved entirely too fast. I’d love to see a third video in the series that follows the “beginner” methodology more, like you did in the first two. This one was just too confusing. Sorry 😦

• I agree too. The first two videos were perfect. But this video leaves me very confused. If I knew why I was doing some of these functions I might understand this a lot better. But this one eludes me. I am going to check out some other books to see what they say.

• I’m having the same issues. It seems like this video has taken a leap of logic that I can’t follow as easily.

• What??? Could you repeat this about 100 times please? LOL Great video until this point. I am totally confused.

• Hi, I’ve noticed that this lesson in particular loses people sometimes. I will be going through and fixing it, but I can say that if you skip the video and move on to further training and it will hopefully click later. Sorry for the inconvenience!

6. Hello Ben,

Thanks for sharing the videos

i have a question ” Why do we need to use False in Vlookup”

7. Hello…

u r really good in excel..
i have a question “why do we need to use False in vlookup”

8. Hi!

You do a great job and are very knowledgeable! You have given me many good, tangible ideas for teaching my students. I really like your videos overall with the exception of the placement of this one. I think this one should belongs in the advanced area.

Thanks for doing this!

suppose you added a little content? I am not suggesting your content isn’t good, however what if you added a post title
that grabbed people’s attention? I mean Video Lesson: Absolute & Relative Referencing |
Free Excel Training! is a little plain. You ought to peek at Yahoo’s
to click. You might try adding a video or a related pic or two to grab readers interested about everything’ve written. Just my opinion, it could bring

10. I don’t understand why you are using a vlookup in a beginner’s course (you even said that most people don’t even know what a vlookup is) and why you are therafter spending 5 minutes messing up your vlookup.

• Hey Anonymous,

Thanks for the constructive criticism. Actually this is one of the oldest / first videos I recorded and at the time I wasn’t entirely sure which way the course was going so I probably should have used a different method to show Absolute and Relative cell referencing.

Sorry if you felt your time was wasted with this lesson, but hopefully the message about cell referencing comes across.

Here’s another site that goes over the difference between Absolute and Relative cell referencing:
http://www.howtogeek.com/school/microsoft-excel-formulas-and-functions/lesson3/

Cheers,

Ben

• On the flip side, it never hurts to get exposed to something advanced you want to eventually understand, even if you don’t get it now.

That way, when it’s introduced later, you’ll already have had that exposure, and things will click even more.

Always a positive side to something.

Cheers,

Harrison

11. Awesome!!!! I really accumulated a lot Excel knowledge from the series videos! Thank U very much!!!

12. If somе one desires tߋ be updated with most up-tօ-date technologies afterward he must
Ƅe visit this web site ɑnԀ bе սp to date daily.

13. Hi, I do believe this is a great web site. I stumbledupon it 😉 I am going
to come back yet again since I bookmarked it. Money and freedom is the greatest way to change, may you be rich and continue
to guide other people.

michael kors handbags outlet

14. Why don’t you use Youtube? I have a PC, chrome, everything updated and half these videos freeze a few minutes in for no reason.

• Freeze on a video can be a hardware video card problem, a video driver problem, or a internet speed problem, good luck fixing it – this is a very good training video on Excel to watch

• Just go to Vimeo (click Vimeo) and download the video. It’s definitely your computer/internet connection at fault here.

15. Hi,
Your videos are very well done. I could not open the current video with IE but it worked with Google Chrome.

Thank you for sharing your knowledge and taking the time and effort to create such useful videos.
Josée

16. Why did u make the totals of the vlookup table 1 row short of the source table? Just curious if it wasn’t accidental or some mysterious clever reason.

17. The latest version of Firefox appears unstable with the flash plugins. Couldn’t view this video in Firefox, but it works just fine in IE.

18. I love this website! But I didn’t fully understand this lesson. I did a VLOOKUP course on Microsoft’s support website, I thought I got it. But in this lesson, I don’t understand what you are trying to do with the second table. I have looked at the formula in the downloadable table so I see the arguments but the goal of the second table is still not clear to me.

• Same here. So disappointed. I am really hoping I can watch this video!

• I don’t have any problems playing it. It seems the people who I’ve heard have a problem are using Mac’s.

I’ll try to re-upload and/or re-render the video and see if that fixes it.

In the meantime, you can try going to the Vimeo page and downloading the video file. It can be found here: http://vimeo.com/30347348

Hope that helps!

Ben

19. Happy to have found your series, Ben! Great stuff! I’m not having problems viewing the videos, except this one keeps crashing my firefox browser a second after hitting play.

• Hey Mark!

The video seems to play fine for me, hope it’s still not giving you issue! Could be a problem with vimeo…

Cheers,

Ben

• I am having trouble viewing this video, also. It either crashes, or when it finally did play (the next day), it is blurry and looks like it is reversed from a normal view.

• It works fine on me. I don’t have a Mac to try it on so I’m not sure what the issue is unfortunately.

You can try going to vimeo.com/excelexposure and see if it works on their site.

• Had the same problem… says adobe flush p[lug in crashed…. same with vimeo…

I tried a different browser like google chrome.. IT WORKED… thanks BEN…

20. quick question, are the worksheets you use on the videos available in the master book? if not, not big deal, i just wanted to see if i could use them to test out the new stuff i learn