Posted by Tonya on January 23, 2002 7:35 AM
I am trying to put together a vlookup function that will go down the first column of the lookup table until it finds the first number larger than my value and then moves over to that column index column (instead of backing up one row).
Ex: actual bodyweight is 123.8
col A col B
124.00 .4762 <- I want this value as the result
Can you tell me how to accomplish this? Do I need to provide more information? I appreciate the help. We are using this for running a high school powerlifting contest this weekend.