please see attached spreadsheet
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
index match
0
Answers
0
The error in your formula is in setting the match type. For an exact match the type should be 0 (zero), like =MATCH(A6,$G$6:$G$23,0).
However, if your worksheet is constructed like the one you published, using VLOOKUP would be the better solution because it's simpler and, therefore, works faster.
=IFERROR(VLOOKUP($A6,$G$6:$H$23,2,FALSE),0)Bear in mind that the lookup column must be the first column in the specified range, with the result column anywhere to the right of it.