Hi.
I have no idea why the VLOOKUP is not working. Cell G2 is supposed to look for the minimum value of column D, then Cell G3 would return the value corresponding to column A via VLOOKUP.
As for now (testing) I used the value of 8.381256785 which should return 13, but no, it does not -_-
why should it return 13
you have
=VLOOKUP(G2,A1:D169,1,TRUE)
SO find the nearest smaller number in column A, as you have 1 and range A:D , and TRUE
G2 has
8.38125678518442
so 8 is nearest
ROW 8
OK so i see you have the value in row 13 column D
Are you expecting to find a NEAREST Value in column D and return the contents in A
Then you may want to look at using INDEX/MATCH
=INDEX(A1:A169,MATCH(G2,D1:D169,-1))
Vlookup - usually looks to the Right of the cell in the range , so if the range is A it will look for a value in A and return a value based on the number of columns from A and included in the range
NOT left of the lookup value , without some manipulation and index/match is easier
Last edited by etaf; 07-03-2021 at 02:17 PM.
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)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks