how do i return a range of values
 

i want to return a range of values from one workbook to another using the
criteria <c6 d6 where c6 and d6 are the results of a formula. using vlookup
i can only bring in one line of data . has anyone any sugestions please....

marcus

The way you've posed your question is so ambiguous that it's almost
impossible to give you a reasonable answer.

A little more detail, please, about the data you're trying to retrieve - how
it's organized, what the criteria might be, etc.

"marcus" wrote:

i want to return a range of values from one workbook to another using the
criteria <c6 d6 where c6 and d6 are the results of a formula. using vlookup
i can only bring in one line of data . has anyone any sugestions please....

marcus

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

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