Get instant live expert help on I need help with using index match instead of vlookup

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

gather data using vlookup/match/index and then transpose accordingly
Solved by E. H. in 11 mins
Please could you help me translate this formula to use INDEX and MATCH instead of VLOOKUP: =iferror(vlookup(A10,'Funds Included in Starting Balance'!$A$2:$C$9,3,false),0)
Solved by O. E. in 28 mins
Using VLOOKUP to match values between two tabs of large workbook. VLOOKUP finds correct cell but displays VLOOKUP formula instead of data in cell. How do I display data in thousands of cells?
Solved by D. L. in 29 mins
Can index + match be used where the "match" is based off of a formula result instead of a number that is inputted?
Solved by O. H. in 28 mins
Either a Vlookup or Match index to find results
Solved by V. A. in 24 mins