# Reverse LOOKUP to find the Second matching value from the bottom

1. ## Reverse LOOKUP to find the Second matching value from the bottom

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.

2. ## Re: Reverse LOOKUP to find the Second matching value from the bottom

=index(b3:b8,match(d3,a3:a8,1))

3. ## Re: Reverse LOOKUP to find the Second matching value from the bottom

In this example, it finds a value of '5', where it should find a value of '100'.

Any ideas?

4. ## Re: Reverse LOOKUP to find the Second matching value from the bottom

ARRAY formula

=INDEX(\$B\$3:\$B\$8,SMALL(IF(\$A\$3:\$A\$8=\$D\$3,ROW(\$B\$3:\$B\$8)-2),ROW(B2)))

5. ## Re: Reverse LOOKUP to find the Second matching value from the bottom

@Fotis

As the OP requests the second value from the bottom up your formula should be tweaked a bit to :
``Please Login or Register  to view this content.``
(array formula of course)

6. ## Re: Reverse LOOKUP to find the Second matching value from the bottom

...from the bottom up

Thanks Pepe.. I think that i need glasses....

7. ## Re: Reverse LOOKUP to find the Second matching value from the bottom

Well, maybe some glasses of Ouzo less

8. ## Re: Reverse LOOKUP to find the Second matching value from the bottom

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.

9. ## Re: Reverse LOOKUP to find the Second matching value from the bottom

Awesome. The change seems to work. Thanks!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1