# Video Lesson: Absolute & Relative Referencing

## Absolute and Relative Cell Referencing

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)

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

1. 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

There is a download link underneath the description.

Hope that helps!

Ben

2. 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…

3. 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

• Hi Adriana,

Yes, the Excel workbook that is reviewed in the video can be found in the Master Workbook. Here’s a screenshot where you can see that it is the spreadsheet entitled “9 – Referencing”:

http://i.imgur.com/cp2Up.png

Let me know if you still have problems.

Ben

4. Thank you! Toggling between this video and the naming video until I really get it all into my head, and move it to my bag of Excel tools!