INDEX/MATCH problem

[sharrison]

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?

 

[Stormseed]

Steve, the Validation List source has all numbers as decimals and not just this one. Your above formula would work if you replace it with this one:

=INDEX(S105:S107,MATCH(R108,R105:R107,1),1) will get you the closest match for the number you are looking up !

Enjoy

 

[sharrison]

Stormseed. That seems to work. I will have to keep an eye on it though. Thanks for your help.