Hi Friends,
I am getting #N/A error while using INDEX MATCH function. The reason for this is that the cell for the lookup_value has a formula. If I remove the formula in lookup_value cell the INDEX MATCH function works well!!
How can I fix this problem.
Thanks,
what is the value in the cell with the formula ?
what result does that formula return, that should be what the index/match will be looking for
if theres an error , than index match will return an error
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi Wayne,
The value in cell with formula is numeric and the format is general. I have tried changing the format. But I still get the #N/A error. I have given the screenshot below. The INDEX formula is in A6 and the cell with value is U6.
Error.jpg
rather than images can you load a sample spreadsheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks