Hi
I am having a issue with lookups and all the sites that i can see don't seem to deal with it the way i am wanting to
I want to perform a look up on based on a number and i want it to pull a record based on a range.
Eg: Value i have = 22 is in 1 table and i want it to find the record based on the range that starts at 21 and ends at 30 out of the following range of records and give me the result C that exists in another table
ID Start End Result
1 0 10 A
2 11 20 B
3 21 30 C
4 31 40 D
My problem is that i cannot figure out how to do this, queries seem obvious, but i cannot program it properly. SQL also does not seem to help me (although i am hardly an expert at it). VBA would seem the best, but i have no idea how to code.
All the usual sources of looks up deal with combo boxes or linking tables together. But those rely on precise lookups. I am needing an imprecise lookup based on range.
Thoughts, comments, suggestions all welcome.
Thanks - Scorp