Thread: Translate INDEX(MATCH) into VBA
View Single Post
 
Old 03-08-2015, 05:06 PM
charlesdh charlesdh is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default
Hi,

Perhaps this may help. I found it on line.

test = Application.WorksheetFunction.Index(Sheets("Worker s List").Range("C3:C13"), Application.WorksheetFunction.Match(1, Sheets("Workers List").Range("D313"), 0), 1)
Reply With Quote