I will try to explain what I'm after as simply as possible.
Lets say i have 4 fields in my table;
A - Number From
B - Number To
C - Colour
D - Fruit
Example data could be:
A - 1
B- 10
C - Green
D - Apple
Then on a userform, i have 3 textboxes, one for a number, one for colour and one for fruit. The idea is the user will enter the number then the next two boxes will be looked up.
How do i perform a vlookup for the colour and fruit, dependant if the number the user enters in the first text box.
For example, if the number entered between 1-10 could be green apple, 11-20 could be yellow banana, etc.
Hope that makes sense. Basically need to perform a vlookup dependant on the range in which the number the user enters falls in.
Lets say i have 4 fields in my table;
A - Number From
B - Number To
C - Colour
D - Fruit
Example data could be:
A - 1
B- 10
C - Green
D - Apple
Then on a userform, i have 3 textboxes, one for a number, one for colour and one for fruit. The idea is the user will enter the number then the next two boxes will be looked up.
How do i perform a vlookup for the colour and fruit, dependant if the number the user enters in the first text box.
For example, if the number entered between 1-10 could be green apple, 11-20 could be yellow banana, etc.
Hope that makes sense. Basically need to perform a vlookup dependant on the range in which the number the user enters falls in.