VLookup sorting from bottom to top

[Legacy 185660]

Hey guys!
I tried googling this, but the answers I got were way too confusing for me to try to edit.
I need this VLOOKUP formula to search from bottom to top to find the last value.

=VLOOKUP(C3,'Signout History'!A:C,2,FALSE)

Thanks!

 

[Domenic]

See if this helps...

http://xl-central.com/lookup-last-instance.html

 

[Legacy 185660]

See if this helps...

http://xl-central.com/lookup-last-instance.html

This is on google docs for more people to access, and there is no LOOKUP function, only VLOOKUP and HLOOKUP. So I don't think this will work

 

[Legacy 185660]

See if this helps...

http://xl-central.com/lookup-last-instance.html

This is on google docs for more people to access, and there is no LOOKUP function, only VLOOKUP and HLOOKUP. So I don't think this will work

Edit: Yeah I tried it out and it gives me an unknown function error

 

[Domenic]

Are you able to use INDEX and MATCH?

Are you able to use an array formula?

 

[Legacy 185660]

Are you able to use INDEX and MATCH?

Are you able to use an array formula?

Yes you can use all of those, thanks!

 

[Domenic]

Try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER, not just ENTER...

=INDEX('Signout History'!$B$2:$B$100,MATCH(2,1/('Signout History'!$A$2:$A$100=C3)))

To avoid having to confirm the formula with CONTROL+SHIFT+ENTER, try the following instead...

=INDEX('Signout History'!$B$2:$B$100,MATCH(2,INDEX(1/('Signout History'!$A$2:$A$100=C3),0)))

 

[Legacy 185660]

Try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER, not just ENTER...

=INDEX('Signout History'!$B$2:$B$100,MATCH(2,1/('Signout History'!$A$2:$A$100=C3)))

To avoid having to confirm the formula with CONTROL+SHIFT+ENTER, try the following instead...

=INDEX('Signout History'!$B$2:$B$100,MATCH(2,INDEX(1/('Signout History'!$A$2:$A$100=C3),0)))

That gave me an error saying "Did not find value 2"
Can you give me your email address so I can possibly add you to the google doc? Might make it easier because then you would be able to see the sheet and try it out yourself.

 

[Domenic]

Try the following array formula, which needs to be confirmed with CONTTROL+SHIFT+ENTER...

=INDEX('Signout History'!$B$2:$B$100,LARGE(IF('Signout History'!$A$2:$A$100=C3,ROW('Signout History'!$A$2:$A$100)-ROW('Signout History'!$A$2)+1),1))

 

[Legacy 185660]

Try the following array formula, which needs to be confirmed with CONTTROL+SHIFT+ENTER...

=INDEX('Signout History'!$B$2:$B$100,LARGE(IF('Signout History'!$A$2:$A$100=C3,ROW('Signout History'!$A$2:$A$100)-ROW('Signout History'!$A$2)+1),1))

Perfect!
That works!
Thanks a lot!

Will this work for all rows of C?