I am having a nightmare and don't know why!!
I have some data in a spreadsheet as below
898 243
998 268
1048 281
998 #N/A
The bottom cell containing the number 998 is the number that I want to find in the data. This value is taken from another sheet in the same workbook. This number you can clearly see is contained within the data.
The #N/A contains the INDEX/MATCH as below
=INDEX(S105:S107,MATCH(R108,R105:R107,0),1) where S105:S107 is the second column of information, R105:R107 is the first column of information and R108 is the cell containing the value 998.
As far as I am aware this should work and should return the value 268, however it continues to return the error. If I replace the link to the other spreadsheet which gives the 998 value with the value 998 then it finds the value 268.
Does anybody know why this is and how to get round it?
I have some data in a spreadsheet as below
898 243
998 268
1048 281
998 #N/A
The bottom cell containing the number 998 is the number that I want to find in the data. This value is taken from another sheet in the same workbook. This number you can clearly see is contained within the data.
The #N/A contains the INDEX/MATCH as below
=INDEX(S105:S107,MATCH(R108,R105:R107,0),1) where S105:S107 is the second column of information, R105:R107 is the first column of information and R108 is the cell containing the value 998.
As far as I am aware this should work and should return the value 268, however it continues to return the error. If I replace the link to the other spreadsheet which gives the 998 value with the value 998 then it finds the value 268.
Does anybody know why this is and how to get round it?