How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX

woah, awesome video

I just found this and it has saved me! Thank you so so much. I'm almost in tears. You have no idea how long I have search for this task. Thank you.

Thank you for saving my life

How would I save sheet one once I’ve extracted the data from sheet 2

Thank you so much. Was really easy to understand.

nice

Talks a lot

Perfect

Thanks, You save my week

hi

The vlookup isn’t working and I could throw my computer

The way you present and explain every single thing is just *Mind Blowing*!!

Truly helpful 🤟🤟🤗🤗

very helpful video with clear instruction

Thanks. It was nicely explained. Kindly make a playlist for MS Excel for better learning.

Brilliant explanation

This was a great help and recap, thanks

still the easiest, best reference for VLookup online. Thanks!

Love it, Simple Explanation and it works

You're the GREATEST TEACHER. Easy to follow the instructions. Clear, concise, helpful. Thank you so much for your time, hard work to teach us. Looking forward to more. Liked, definately subscribed !

This was super helpful, thank you

This is the formula:

=vlookup(a51&"*",EXP!$101:$101,87,0)

EXP = 2nd sheet

My goal is to automatically move to cell column 88 while dragging down the formula in the 1st sheet

Can u help with my predicament in this drag down formula in group cells and copy a cell from another sheet?

I have been searching for vlookup tutorials and I must say this is the best tutorial found so far.
Think I found what I'm searching for, thanks 👍

Too much technology I

Thankyou!

Its a Story Telling Video. Stretch the 3 Minutes video into 15 Minutes. Very Poor Practice.

Thank you so much it's helpful 🥰

you deserve my like
you are a good man brodah

I banged my head against the wall for 4 hours till I found this video. THank you!!!!

i have two spared sheets one is called stock with price
and another is called calculator
in a stock sheet there is 3 columns category and sub category and price
that shows in calculator sheet in list form
i am not able to get a specific price of category and subcategory wise

ex fruit is category and apple is sub category and 100 is price
in calculator sheet fruit and apple are showing but how can i get the price of it
please help me............
looking to hear from you..

i have two spared sheets one is called stock with price
and another is called calculator
in a stock sheet there is 3 columns category and sub category and price
that shows in calculator sheet in list form
i am not able to get a specific price of category and subcategory wise

ex fruit is category and apple is sub category and 100 is price
in calculator sheet fruit and apple are showing but how can i get the price of it
please help me............
looking to hear from you..

Hi, can you make a video on how to add up all the quantity of a unique item?
Like in your sample table, how do you rearrange the table by showing the total pound of Ethiopia is 25; Blue mountain is 26, Kona is 49 and so on.
Thank you sir

I have a question! I have two worksheets. one work sheet consists of CustomerName in one column and Income in another column. The second sheet consists of CustomerName in one column and email in another column. The sheet with customername and income has been filtered to provide the customers I am interested in and now I want the sheet with the customername and email to be filtered to only show the customers that I have on the customer and income sheet. How do I do this?! Thank you so much in advance for any help

What if I am trying to do a vlookup to bring everyone from a certain location from another workbook

THANK YOU!! This video has saved my WHOLE life! Well described and narrated 🙏🏽😊

Strange but in my excel doesn't work, it shows only N/A

The knowledge you dished in this video is priceless and timeless! 8 years down the line this still works. Thanks Bob!

Thanks man , it helped

Very well explained , good

Thank you for helping me understand it better.

Worked perfect. Thank you!

can anyone help

how to fill without mouse drag?

match and replace to columns together google sheets text to columns

Arigatou

Great lecture. Thank you

Exactly what I've been looking for and explained very well!

Thank you So Much!!

is extracting data possible with advanced filter