?? Work at Pickup Points � Flexible schedule

Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)

excelisfun 131 views

Download Video

Comments

Great Video! Thank you for taking the time to post it brbrWould you mind answering a clarifying question? brbrAt 11:20, you mention that you can do "many more columns" Let's say my goal was to use VLOOKUP to search a table area and instead of returning the 2nd cell only, I want cells 2,3,4, and 5 to show up brbrIs that possible?
Comment from : @nyman86PoliceRadio

Great tutorial, thanks
Comment from : @jackballenger4670

Thanks man! Easy to understand Help me a lot! :)
Comment from : @jefrinusjuanis2491

thank you
Comment from : @phuongdang5553

very good tutorial thanks
Comment from : @Bolderbas

I was having panic attacks because I did not understand vlookup or ifs! for my exce quiz on tuesday! but once I saw this it helped me a lot thank you so much for your help
Comment from : @fiorellaanthuanechirinos8089

You are the man
Comment from : @eddiebirk5937

This really helped me out Thank you!
Comment from : @jordankaplowitz3148

I have watched a TON of your excel videos and I just have to say you are an amazing teacher The way you explain such difficult concepts in such a fun and engaging way is truly commendable You literally make excel fun and thank you for that :)
Comment from : @5ri5hti

thank you
Comment from : @OMGitscasper

Thank you! This about the only video that showed me exactly what I wanted to know! Life saver I was getting a little frustrated with my homework over here!
Comment from : @skinnyred14

When you copy the formula, you must lock the table Here is a video ALL about cell references: "Excel Cell References 15 Examples Formulas, Conditional Formatting & Data "
Comment from : @excelisfun

I have a quick questions: Under which condition do you Lock or Unlock the table array? thank you so much
Comment from : @frankyen5855

Glad you liked it!
Comment from : @excelisfun

Awesome i've been looking all over for this!
Comment from : @Xokoretto

Amazing! Thank you for the videos
Comment from : @caylendenuccio1279

YOU ARE A CHAMPION AMONGST MEN THANK YOU SIR
Comment from : @weare21century

You are welcome!
Comment from : @excelisfun

this is just perfectthanks for sharing
Comment from : @aprilwinlian

Can you refer me to a video that shows VLOOKUP that only shows a certain range of numbers, but if the result does not fall in that range leaves the cell blank? It would be like if you only cared about the boomerangs that cost between 15 and 20 dollars in this example
Comment from : @mwgiguere

Sometimes when I v look up , i get some lines as #N/A when there is in fact data in the other table , so it picks up some results but get the N/A in some , why is this and how can I fix it ? thanks
Comment from : @Da_Crow

Hi Mike, I need Look-up Tutorial Recommendation to solve the following problem: look-up Function is providing 1 less look-up reference, instead of the right look-up cell reference Thx
Comment from : @InfoTech6598

You are welcome!
Comment from : @excelisfun

Thanks a lot for making things simpler and easy to understand
Comment from : @MRadhaMadhavi

Thank you incredibly for sharing these videos!
Comment from : @RachMarie79

You only need absolute when you are "copying the formula" and you want the references locked
Comment from : @excelisfun

Why did you originally use absolute values on the first example but did not later on (the f4/$signs)?
Comment from : @crystlicetears

You are welcome!
Comment from : @excelisfun

really good thanks
Comment from : @rodrigorlugo

Excellent video demonstrations! Very informative and intuitive!
Comment from : @louathome1

I am glad that you like it!
Comment from : @excelisfun

You are welcome!
Comment from : @excelisfun

Thanks for the clear and concise instructional video You are awesome Much appreciated
Comment from : @4CIdaho

You are welcome! I am so happy to hear that your new Excel skills made you look good - that is why I post the videos!
Comment from : @excelisfun

Thank you, thank you, thank you!! You made me look so good in front of my boss today!
Comment from : @supercolourme

You are welcome both times!
Comment from : @excelisfun

thx again
Comment from : @cavemankhs

@7aya84 , you do not need to make it absolute all the time If you will never copy the VLOOKUP formula to another cell, there is no need to make it absolute
Comment from : @excelisfun

@TheTinkletron , you are really awesome and smart at such a young age!! Keep up the good work!
Comment from : @excelisfun

I am 14, and watching your videos to study for the expert test, i have already passed the certification, but I wanna pass the expert test Your videos are perfect for this! Thank you!
Comment from : @TheTinkletron

@stevensiro , I am glad that the videos help!!
Comment from : @excelisfun

@MrSynths , you are welcome!
Comment from : @excelisfun

Very useful, thanks!
Comment from : @MrSynths

@dukk77777 , try: Highline Excel Class 07: VLOOKUP function formula 7 Examples
Comment from : @excelisfun

How can we use the VLOOKUP when we want to use a table from another page?
Comment from : @dukk77777

@Decnet01 , youa re welcome!
Comment from : @excelisfun

@ExcelIsFun Thank you so much
Comment from : @Decnet01

@prettyboicraig , you are welcome!
Comment from : @excelisfun

@killmenow418 , I am glad that the video and the conceptual breakdown of the VLOOKUP helped!!
Comment from : @excelisfun

Yes that is what I have used and it will not work i have a data set with no "<2B' in the entire column and using that formula it says that there are 8 "<2B" in the column Thanks
Comment from : @tmftmftmf

Great video, saving me hours of work Can you plesae help me with this problem, I am using countif to count a large data set with '<2B' in the column The count if will not count the '<' symbol do you know how i can make it count them, works fine on all others eg 2B, 2P, 2A, 3B, 3P, 3A Thank you
Comment from : @tmftmftmf

nicely done
Comment from : @evenacona

Do know how can I display multiple worksheets from the same workbook? By the way I enjoy your all video and they are all helpful Thanks
Comment from : @myunlu1

I don't seem to have a problem I am not sure what is going on Did you try a different browser? Google Chrome, Motzilla?
Comment from : @excelisfun

it stops on the best part
Comment from : @TheCarlalison

You are welcome!
Comment from : @excelisfun

Thank You!
Comment from : @ruperboy97

COUNTIF or COUNTIFS See this video: 2010 Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria) or Excel Magic Trick #180: COUNTIF function formula 21 Examples or Excel Formula Efficiency 4: SUMIFS & COUNTIFS Are Fast
Comment from : @excelisfun

How do you get the number of people are there in a group like male or female?
Comment from : @ruperboy97