Find Last instance colum A and return corresponding B Value
Hi Will,
Am Tue, 2 Jul 2013 12:29:17 +0100 schrieb Will3001:
Column A Column B
100 N
101 N
101 Y
102 N
103 N
103 N
103 Y
104 N
104 Y
for 100 try:
=INDEX($B$1:$B$100,LOOKUP(2,1/($A$1:$A$100=100),ROW($1:$100)))
you also can change the value with a cell reference
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|