Hi,
Can teach me how to do a vlookup based on a range of cell.
Attached is the example and the highlighted part is the result I want to achieve.
Thanks.
vlookup range.xlsx
Hi,
Can teach me how to do a vlookup based on a range of cell.
Attached is the example and the highlighted part is the result I want to achieve.
Thanks.
vlookup range.xlsx
Use VLOOKUP with the last parameter set to 1. Lookup list has to be sorted of course (as it is). VLOOKUP with the option 1 goes down the list and stops at the largest number that is stilll smaller than your lookup value.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Hi
Add a column with the first number of your weight range and then use this.
Formula:Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
you can use
=INDEX($G$3:$G$10,MATCH(A2,$F$3:$F$10,-1))
which will lookup the nearest , largest value - But the table will need to be sorted differently - as shown in attached
Note
Should Weight of 1 be A and not B ?
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks