forgotten025
New Member
- Joined
- Aug 14, 2007
- Messages
- 4
hi... i was wondering if u cud do the opposite of vlookup... wat i mean is how instead of being able to have a table of values and getting the value just smaller than the lookup value, is it possible to get the value just bigger...?
my table has a list (not an array) of cross-sectional areas which is the first column, and i want it to return the dimensions (which includes text - eg "123 x 45"), and my lookup value is a calculated cross-sectional area, but i want the dimensions of the cross-sectional area just bigger than the one i calculated...
i hope that made sense... i don't need vlookup to do the job... anything will do...? cud anyone help?? and get back to me asap...???
my table has a list (not an array) of cross-sectional areas which is the first column, and i want it to return the dimensions (which includes text - eg "123 x 45"), and my lookup value is a calculated cross-sectional area, but i want the dimensions of the cross-sectional area just bigger than the one i calculated...
i hope that made sense... i don't need vlookup to do the job... anything will do...? cud anyone help?? and get back to me asap...???