Lookups

[Merlin]

Can anyone advise on how to do a lookup that picks up the previous value in a column in a table ?

The value will be repeated several times in the table and I want to refer to the last occurrence. The table is not sorted and the most recent data is added to the bottom of the spreadsheet.

All the lookup funstions seem to pick up the first instance of the data - how do I get a reference to the last ?

Thanks

 

[Aladin Akyurek]

I must be doing something wrong, because I just get 0 returned (cell F10).

OK. I picked up the new sample to a sheet in A1:L9, with all labels in row 1.

Now, I have to know what lookup values did you try out? And, which formula did you use in F10?

Aladin

 

[Merlin]

Aladin -

I think your suggestion now works, although I don't really understand it. My thanks for your support.

 

[Aladin Akyurek]

On 2002-04-29 05:42, Merlin wrote:
Aladin -

I think your suggestion now works, although I don't really understand it. My thanks for your support.

I you'd like to know how SUMPRODUCT works, have a look at:

http://www.mrexcel.com/wwwboard/messages/8961.html

Aladin