Forum Discussion

Anthony Smith's avatar
Anthony Smith
Brass Contributor
Jul 19, 2018
Solved

How to Return Column Data Based on Matching Row Data in First and Second Worksheets

Hi All,   I am not really sure how to explain what I want to accomplish, but I believe what I am looking to do is possible with INDEX and MATCH. Basically, I have a column of data on one worksheet ...
Formulas & Functions
Need Help
  • Matt Mickle's avatar
    Matt Mickle
    Jul 20, 2018

    Maybe just try using a vlookup:

     

    Here is some additional info on how the function works:

     

    https://www.excelcampus.com/functions/excel-vlookup-explained/

     

Matt Mickle's avatar
Matt Mickle
Bronze Contributor
Jul 20, 2018

Maybe just try using a vlookup:

 

Here is some additional info on how the function works:

 

https://www.excelcampus.com/functions/excel-vlookup-explained/

 

Anthony Smith's avatar
Anthony Smith
Brass Contributor
Jul 20, 2018

What would be the difference between using a VLOOKUP function and a combined INDEX and MATCH function?