Equivalent to Excel Match() function?

[j_fulcher]

Hi all,

I have percentile data in the following format

Percentile	X
0.1	58
0.2	64
0.3	72
0.4	85
0.5	99
0.6	105
0.7	123
0.8	132
0.9	136

For any given value of X I need to be able to output the percentile above and below the value. For example if X was 102 I need to be able to output 0.5 and 0.6.

In Excel I would use a Match() function but I don't think that Match() in Qlik works the same way? Please correct me if i'm wrong!

Thanks in advance for any help!

[Anil_Babu_Samineni]

How X was 102 and will that come as source or user will enter in the input box?

[j_fulcher]

Hi, sorry I couldn't reply sooner. 

X is loaded with the data so the user will not be able to change the value but it may change when the data is refreshed.