As you know, a formula can return only one visible result to a cell so to do
what you want you'd need an array of formulas. While you may be able to
cobble something together to do this, Excel's Data, AutoFilter and Advanced
Filter were provided with this kind of thing in mind. They are no
"automatic" like formulas are but they can at least be automated via
macro...


--
Jim
"marcus" wrote in message
...
|
| apologies, sheet 1 contains a list of technical specifications of
| tyres.these are formatted in the usual manner for a vlookup function. in
| sheet 2 users input 2 variables which when calulated produce 2 figues
..what i
| want to do return all values from the table in sheet one which lie between
| these 2 figures eg value 1 and less than value 2. as i said i have tried
| lookup functions but as far as i can see they will only allow me to
produce a
| single line as opposed to a range.
|
| hope thats somewhat clearer
| cheers