hi,

Am Sat, 13 Jul 2013 15:26:09 -0700 (PDT) schrieb :

Hi, Claus, thanks for the new formula. This one works, too, but again only if I make the ROW(A1) into an absolute reference. I don't know if it makes a difference, but in the real spreadsheets I'm working with, I'm not using an individual word like "Apples" in the search, I'm using cell references that go all the way down the column. The actual formula as I just tested it looks like this:

then something is wrong.
Please look he
https://skydrive.live.com/#cid=9378A...121822A3%21326
for the workbook "Small"
Rightclick and download it.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2