Ok tried to follow that however it doesnt work from the second part onwards
=SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1) )
that just returns "VALUE" and everything else is the same from that point
forward
"Gary''s Student" wrote:
You want to lookup and get multiple results. Kind of like Autofilter but with
a formula. This is well described in:
http://office.microsoft.com/en-us/ex...260381033.aspx
--
Gary''s Student - gsnu200851
"CP" wrote:
I am looking to see if excel can help with a form of query.
Sheet2 contains various data similar to:-
Code Description value (basicly a stock list)
Sheet1 has a Cell (A1) where I type any part of code or description and any
matching results from Sheet2 appear in rows A3 to A1000
I have failed upto now in figuring this one out - any help?