LinkBack URL
About LinkBacks
How do I return the second matching value from the bottom of a table?
In the attached example, the red, bold value is what I'm trying to return, but it must be found from the bottom up.
How do I return the second matching value from the bottom of a table?
In the attached example, the red, bold value is what I'm trying to return, but it must be found from the bottom up.
=index(b3:b8,match(d3,a3:a8,1))
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.
In this example, it finds a value of '5', where it should find a value of '100'.
Any ideas?
ARRAY formula
=INDEX($B$3:$B$8,SMALL(IF($A$3:$A$8=$D$3,ROW($B$3:$B$8)-2),ROW(B2)))
@Fotis
As the OP requests the second value from the bottom up your formula should be tweaked a bit to :
(array formula of course)
Please Login or Register to view this content.
...from the bottom up
Thanks Pepe.. I think that i need glasses....
Well, maybe some glasses of Ouzo less
Ouzo, is for the Summer-near the sea- or the sunshine weekends of the winter!
In any case, what is sure is that is not good idea at all when i am in the office.
Awesome. The change seems to work. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks