Vlookup

[Dianne]

I want to pull a specific range of data, based on a
condition and past 10 of the results to a different
sheet. ie. If the value of A1 - A13 is (<=1.50 and >=-
1.50) then pull 10 values to sheet 2 c24-c34.
Thank you!

 

[ozzie]

If the value in a1 less a13 is between your parameters,
then in cells c24 though c33 put ten specific values
values? And if it is not?

BTW cell c34 is the eleventh cell. hopefully I'll remebmr
to look tomorrow for your answer....

 

[Guest]

What I am looking to do -is populate a rate sheet. I am
pulling data off the internet via a DDE links, to populate
a rate history. (approximately 15 different rates with
different points for different products 30yr, 15yr..). If
the points are within the range of 1.5 to -1.5, then I
pull the rate and point information to the rate sheet for
each product. But- no more than 10 (or less) lines of
rates. If there are not 10 values then only pull the
values in the point range. If 10 lines are not available
then we will need to manually adjust the range of 1.5 to -
1.5 to add additional rate history.

BTW. Thank you very much..