Find Last instance colum A and return corresponding B Value

Posted to microsoft.public.excel.worksheet.functions

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find value in column, return value in same position of other colum	Josiecorey	Excel Worksheet Functions	1	June 17th 08 02:12 AM
A function to find a phrase within a range of cells and return the address of the first instance.	[email protected]	Excel Programming	2	December 5th 06 07:02 PM
Look up data in colum a and find match in colum b	Chris(new user)	Excel Discussion (Misc queries)	1	March 22nd 05 01:41 PM
Check data on colum A and find match on colum b	Chris(new user)	Excel Discussion (Misc queries)	3	March 20th 05 04:45 PM
Look up data in colum a and find match in colum b	Chris(new user)	Excel Discussion (Misc queries)	1	March 19th 05 09:27 PM

All times are GMT +1. The time now is 05:44 PM.

Menu

About Us