Forum Discussion
Index - Match array that has multiple formulas in cells.
I need to be able to organize a list of items by searching one column/row and then having the the result of the search display them next to the numerical row.
When I use the INDEX-MATCH formula I keep getting #N/A. I believe it is due to the fact I have formulas in the column/rows it is searching.
I've tried for 2 days to find a way to match the contents in a cell instead of the formula but have not found any solutions.
2 Replies
You screenshort is different form the file attached to your post, it's hard to say what exactly you'd like to calculate.
If make a guess, in row 7 of the file you have texts which represents 042, 043, etc. In row 29 of the file 042, 042, etc are numbers formatted with leading zero. Thus MATCH() on them returns #N/A error since there are no matches. You need to convert texts to numbers using double dash in front within the formula.
YOU ARE MY F***ING HERO.
THANK YOU SO MUCH FOR YOUR HELP.
I TRIED TO REPHRASE THAT QUESTION FOR A WEEK ON GOOGLE AND IT NOT ONCE LEAD ME TO THE DOUBLE DASH.
THANKS AGAIN
