LinkBack URL
About LinkBacks
i think you can use this shorter non array formula
=INDEX($B$4:$B$21,MATCH(1,INDEX(($A$4:$A$21=F4)*($B$4:$B$21<>""),0),0))
or
=LOOKUP(1,1/(($A$4:$A$21=F4)*($B$4:$B$21<>"")),$B$4:$B$21)
i think you can use this shorter non array formula
=INDEX($B$4:$B$21,MATCH(1,INDEX(($A$4:$A$21=F4)*($B$4:$B$21<>""),0),0))
or
=LOOKUP(1,1/(($A$4:$A$21=F4)*($B$4:$B$21<>"")),$B$4:$B$21)
Last edited by martindwilson; 12-04-2013 at 09:30 PM.
"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
Thank you all very much for your help.
All the best!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks