I am trying to find data from columns A:E in Master and transfer the unique row information from columns F:I to other spreadsheets.
I've tried using Match/Index function just on columns A:E so far but I cannot get it to work.
=INDEX('Schedule of Works'!A$3:F$27,MATCH($A$1,Master'!E$3:E$27,0))
Bookmarks