gimli
05-17-2010, 07:27 AM
Hey all,
Im thinking outloud here cause im unsure how to accomplish something. Not sure if INDEX/MATCH will work...im pretty sure VLOOKUP will not..
anyways
I want to pull data from a table if the lookup value falls between 2 values..
Ex.
Table
2 Cortney
2.5 Parviti
2.75 Jerry
3 Amanda
If the lookup value is 2.5 and 3...I want to pull data if the value is >=2 or <=3. I will have the same formula in multble cells because there can be multible matches.
So given the above example
First match = Cortney - place value in cell E1
Secont match = Parvity - place value in cell E2
And so on
VLOOKUP will only pull one instance...Match wont work...
any ideas will be great. Cant seem to get index/match to work with a formula..
thanks
Im thinking outloud here cause im unsure how to accomplish something. Not sure if INDEX/MATCH will work...im pretty sure VLOOKUP will not..
anyways
I want to pull data from a table if the lookup value falls between 2 values..
Ex.
Table
2 Cortney
2.5 Parviti
2.75 Jerry
3 Amanda
If the lookup value is 2.5 and 3...I want to pull data if the value is >=2 or <=3. I will have the same formula in multble cells because there can be multible matches.
So given the above example
First match = Cortney - place value in cell E1
Secont match = Parvity - place value in cell E2
And so on
VLOOKUP will only pull one instance...Match wont work...
any ideas will be great. Cant seem to get index/match to work with a formula..
thanks