Lookup Problem:using the same name

Hi,

I am trying to lookup the next value in the list using the same name, for example:

OTHER 125
OTHER 140
OTHER 150
OTHER 101
OTHER 250

So I need to be able to lookup: "other" and bring back "125", then lookup the next value "other" 140 etc etc etc. Does anyone have any ideas?

Cheers

This depends a lot on your setup. Do you have a sample .zip of your file that shows how you want to search?

For example, how would excel know WHICH other value you want to return?