I have done some poking around the internet but have not found exactly what I am looking for. I have found ways to look up a last occurnce using LOOKUP but I need to match multiple criteria.
this obviously returns the first occurence but I need the last. any help would be appreciated.Formula:
Please Login or Register to view this content.
Use a BigNum lookup.
=LOOKUP(2,1/(D:D=B1&A148),B:M)
This matches to the last non-error of a set, where each match equals a number and each error is skipped.
Therefore, =LOOKUP(2,1/({1,0,1,0,1}=0),{bob,mike,sally,tom,dave}) = tom
Last edited by daffodil11; 02-28-2014 at 07:28 PM.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
lookup should work
=LOOKUP(2,1/($d$2:$d$1000=$B$1&A148),$b$2:$b$1000)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Not sure where I was wonking up on the LOOKUP but I got it to work finally. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks