Thanks:  0
Likes:  0

Thread: Need to pick numbers in a range of numbers

1. On 2002-05-08 10:40, Wing-it wrote:
Please don't give up on me know!!!!
I'm not sure I understand what you want at all. Maybe you should produce, given a pair (T3 and U3 values), the expected results for 5 rows of sample that you posted along with the reasoning how you arrived at them.

2. well, lets start over,,,,
in cell T3 and U3 are the numbers I enter in, t3=500 or 520 or 490 or factors of 10 +/-, U3= is the other end of the range, +/- 10. these number change pending on what range im looking for.

the data that the range is looking in is
526 454 the result
510 477 "
500 471 "
507 473 "
500 495 "
530 500 the result.

now I don't know how easy this is but pending on what I enter in t3 and u3 the formula should check between the two columns to find a match or close match to the number spread I entered in t3 & u3, or should i say if i entered 500 in t3 and 490 in u3 the result should indicate which row in the data fell in between the assigined numbers i entered in t3 & u3, nothing over or under but in between or exact.

thanks

3. On 2002-05-08 10:40, Wing-it wrote:
Please don't give up on me know!!!!
Hi Wing-it:
Looks like you are having difficulty describing what you are trying to accomplish. Please state clearly:
1. in which cells are the lookup values
2. in which cells is your list data
3. which number are you looking up for in what range of cells
I am sure if you can clearly define your problem, the solution should be not that hard to find.
If you want to email me your worksheet with a clear description of what you are trying to accomplish, I will be glad to look at and respond.

Good Luck!

4. thanks I sending now

5. On 2002-05-08 11:16, Wing-it wrote:
thanks I sending now
Hi Scott:
As discussed with you, there was need to add another parameter for tolerance up and down to work with your search values. I have emailed the worksheet back to you.
Please post back if it works for you ... otherwise explain a little further and let us take it from there!

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•