LinkBack URL
About LinkBacks
Why is this very simple Index-Match not working. I am doing something much more complex and even testing this as a VERY simple formula it is not working...
=INDEX(A24:B27,MATCH(A31,A24:A27,0)
Why is this very simple Index-Match not working. I am doing something much more complex and even testing this as a VERY simple formula it is not working...
=INDEX(A24:B27,MATCH(A31,A24:A27,0)
=index(a24:b27,match(a31,a24:a27,0))
Ben Van Johnson
Sorry, the extra paranthesis was already in there.
Could the type of file matter. Even a VLOOKUP will not work...
What is in A31? are they the same type in your range a24:a27? they should be both numbers or text type.
are there leading/trailing spaces?
Edit: Yup double posting even on PM's. Started early this morning.
Last edited by vlady; 10-15-2014 at 09:27 PM.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Add a column number (or post a workbook)
=INDEX(A24:B27,MATCH(A31,A24:A27,0),2)
May be check out for formula calculation set it for automatic
☚ Click ★ just below left if it helps, Boo?ath?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks