Lookup with updating data?

[pad70]

Hi,

I am streaming data from an outside source,

Once the data has streamed in, we are calculation percentage changes. This field is continuously updating. I am trying to compose a table of the biggest changes so I got the Max,Large),2)......... and placed them in a column. I then tried to Lookup the value returned for eg. Max and place the title of the component in the destination cell. This does not work.

I think it isn't working because the Data is updating every second and the max figure is always changing too.

Does anyone know how to overcome this?

[NBVC]

You're going to need to show an example or 2 of the situation and the expected results.