VLOOKUP Introduction, Explanation, Example in Excel (2 of 2)

[gelolo020407]

blurred video...

[gelolo020407]

can u explain what the use of dollar sign in the vlookup formula in the table array?thanks man

[ObiWan346]

This one is a little blurry, but you really made sense of this craziness! Im going to visit your website. Thank you!

[unaqi88]

I am coming off a backlog of 2 exams and have an assignment due in 3 hours on vlookup. This has helped me immensely. You are a life saver. Keep up the good work.

P.S: a better quality video would go a long way in making the presentation better.

[ExcelisHell]

@unaqi88 sorry about the quality. I've made better quality tutorials for vlookup on youtube but they don't seem to rank as high in the search rankings (no idea why this happens).

[Naouac]

@ExcelisHell

Hi

THanks for the video..very nice'

one question though, what if we have two same family names in the first column?? lets's say Davis (x2)

thanks again

[ExcelisHell]

@Naouac This was a very simple example. In your case, you would want to have a unique id number for each user. That way, it would be impossible to have a duplicate. There are a number of tutorials that explain this at teachmsoffice . com

[royald3]

great information but poor video make a better 1 next time like tha first 1

[ExcelisHell]

Good point. I'm now going over my old tutorials and updating them all in HD but also with Excel 2007. There will be some new Vlookup videos coming soon.

[PrincessWithSkills]

You do a much better job of explaining vlookups than my college textbooks do.

[ExcelisHell]

Thanks!

[tirathmistry]

Awesome tutorial ExcelisHell!!

Another part 2 Vlookup example is also awesome

I can say your both vlookup tutorial is like a Gold tutorial for me

Please keep uploading new tutorial from us

Thanks God Bless :-)