Forum Discussion
Index & Match within a Matrix
Hi, I'm trying to use the index & Match function to look up a number along the side and letter across the top and return the value where they meet. I've included a column and row to show where th...
It looks like 'Upper'!B50 contains the text string "21".
If NDT!A2:A26 contains the numbers 21, 22, etc., MATCH will return #N/A
The 21 is the result from another calculation made by a different formula- does this mean I need to ensure both are same format for this to work?