Using VLOOKUP and MATCH To Retrieve Data from A Table Excel Tutorial

Using VLOOKUP and MATCH To Retrieve Data from A Table Excel Tutorial

This video shows how to use VLOOKUP and MATCH to retrieve data by name for a certain Date\Round. Search vertically for name then match it by searching the co…

Don’t forget to check out our other video tutorials or share this video with a friend.

1 Star2 Stars3 Stars4 Stars5 Stars 0 votes
Loading... 1,557 views





2 responses to “Using VLOOKUP and MATCH To Retrieve Data from A Table Excel Tutorial”

  1. Andrew Kakumba says:

    Hi Alex, I need your help in just to hours from now, I have an interview
    tomorrow and I was told to find out about VLOOKUP, now my problem is, if I
    delete data (eg. a1-Site ID as column heading, a2,a4-Site ID numbers) yet I
    have another worksheet with those site IDs but not in order, how can I use
    VLOOKUP to import those site IDs from another workbook and what could be
    the value here (remember the site ID column is empty)

    If possible get back to me on +256 703 667 640

  2. Craig Schmitt says:

    Alex. Thanks for this video, the formula was exactly what I needed, but I
    have one problem. The match function is not working correctly. It is
    pulling data from an adjacent cell (2 cells over to the left) consistently
    (I am using the MATCH function in a row of dates. Any ideas on how to
    correct this?

Leave a Reply to Andrew Kakumba Cancel reply

Your email address will not be published. Required fields are marked *