Help-> Index+Match formula pulling wrong values

Hi and welcome to the forum!

"at times the formula pulls the wrong number". I'm afraid that this isn't very useful as it doesn't say for which data the formula doesn't work and so we are left guessing a bit.

Also, I'm sure you'll appreciate that it's often useful to have an actual Excel sheet in which to experiment with possible solutions - in this case, since you haven't posted one, and since a 'general' solution is hard to give with such particular data, that would mean forum members having to reconstruct your pasted data in an Excel sheet (including most likely the Named Ranges, etc.), which would be time-consuming and not something that everyone would be prepared to do.

I'm sure if you attach an actual workbook then your problem will be dealt with quite quickly.

Regards

Hi and welcome to the forum

This is 1 of those times when using range names in formulas makes them more difficult to check.

You have a number of problems in your formula...
1. you have the row and column parts swapped around...
=INDEX(Data,MATCH(C19,Input23,0),MATCH(B19,Input24,0))
2. your ranges need to be ALL the same size with respect to the rows and columns
In your named ranges, they all need to start in B3 and then go down to row 10 (for the 1st match) and across to I for the 2nd match.

This is what the formula should look like with just regular ranges...
=INDEX($B$3:$I$10,MATCH(C19,B3:B10,0),MATCH(B19,B3:I3,0))

Happy to help and we are really glad to have you with us

If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 at the bottom of my FIRST post to this thread)