Thread: Index and match issue

Good morning everyone,
I am having trouble with a formula on indexing and matching some information from 1 page to the next. It keeps bringing in information from a cell that im not referencing,,,please see attached sheet to see what im taliking about,, any help will be greatly appreciated ...ok well i cant attach the sheet i got an error code 'Your submission could not be processed because a security token was missing.:"
So here is my formula
IFERROR(INDEX(Ground3!$A$2:$AQ$10,MATCH($B$2,Ground3!Y2:Y10,0),MATCH($S$1,Ground3!$A$1:$AQ$1,1)),"")
And the information that i am trying to get is located in column T

Why are you referencing Y2:Y10 in the Row Match argument?



Maybe Try... assuming you want to match B2 to A2:A10

=IFERROR(INDEX(Ground3!$A$1:$AQ$10,MATCH($B$2,Ground3!$A$1:$A$10,0),MATCH($S$1,Ground3!$A$1:$AQ$1,1) ),"")

Try:

=IFERROR(INDEX(Ground3!$A$2:$AQ$10,MATCH($B$2,Ground3!$Y$2:$Y$10,0),MATCH($S$1,Ground3!$A$1:$AQ$1,0) ),"")

It's the 0 in the last MATCH() that finds exact match.. you had 1, which finds approximate match in ascending ordered list.