Hi,
I have been having trouble lately using different search functions. I have tried Vlookup, match, Index match etc. and each time I do this it comes up with an error. The values do exist in the source data and they present themselves when I double click on the cell and push enter. Does anyone have a solution to this problem without me having to go in and click enter on every cell (I have about 4,000)
The file I have uploaded is an example - you can see that cell C7 is #NA however the match does exist, if you F2 / double click on A7 and then click enter, the information in C7 is correct. Any suggestions?
Much appreciated.
Michael
I have been having trouble lately using different search functions. I have tried Vlookup, match, Index match etc. and each time I do this it comes up with an error. The values do exist in the source data and they present themselves when I double click on the cell and push enter. Does anyone have a solution to this problem without me having to go in and click enter on every cell (I have about 4,000)
The file I have uploaded is an example - you can see that cell C7 is #NA however the match does exist, if you F2 / double click on A7 and then click enter, the information in C7 is correct. Any suggestions?
Much appreciated.
Michael