Thread: [Solved] lookup on the same row and return next value
View Single Post
 
Old 03-16-2015, 11:57 AM
Snakehips Snakehips is offline Windows 8 Office 2013
Advanced Beginner
  
Join Date: Mar 2015
Posts: 36
Snakehips is on a distinguished road
Default
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.
Reply With Quote