Hi,

What I'm looking to do is, I have a cell. Call it A.

I have another list, say, B and C, which has values, e.g;

10, 100
15, 200

What I'm trying to do is:

Say, A is 5, this means that 100 should be returned, if its 12, 200, 10,100
etc etc.

My understanding of lookup is that it would search for the exact value, not
the 'band' of it.

Anyone give me any advice as to the best way to go about this please?

Thanks,

Ben


--
BWGames
to email change de.news to de-news