lookup on the same row and return next value

		Microsoft Office Forums > Microsoft Excel > Excel
lookup on the same row and return next value

FAQ

Thread Tools

Display Modes

03-16-2015, 11:57 AM

Snakehips

lookup on the same row and return next value

Windows 8

Office 2013

Advanced Beginner

Join Date: Mar 2015

Posts: 36

souza.eq,

Try in V5 and copy down.....

=INDEX(Table1[[#This Row],[plant]:[invent66]],1,MATCH(Table1[[#This Row],[plant4]],Table1[[#This Row],[plant]:[invent66]],0)+1)

Hope that helps.

Tags

excel 2010

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup	Tony Singh	Excel	3	03-06-2015 11:03 AM
Possible Lookup	Karen222	Excel	3	01-10-2012 05:41 AM
lookup dates and return corresponding data	newton.rogers	Excel	7	08-15-2011 11:50 AM
LookUp	aztiguen24	Excel	5	05-24-2011 03:57 AM
Help with Max or lookup fomula to return a name forAmaxValue	dutch4fire23	Excel	0	07-28-2006 01:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:35 PM.