Hello again. I've change the argument format on my "Sub TaskDescription()". It works, except that it keeps repeating the first value throughout the whole column. HOWEVER, the same formula WORKS PERFECT on a REGULAR EXCEL CELL. All suggestions are welcome. Thanks.
This is my new Sub:
[CODE]Sub TaskDescription()
Range("ScopeOfWork[TASK DESCRIPTION]") = _
[INDEX(TaskDescription[TASK DESCRIPTION],MATCH(ScopeOfWork[CODE],TaskDescription
Hi There. I'm developing a project. Trying to match my "ScopeOfWork[CODE]"-COLUMN with my "TaskDescription[TASK DESCRIPTION]"-COLUMN using the INDEX/MATCH functions. But I am getting the "#NAME?"-ERROR. Can someone help to find my mistake? Thanks.
I've attached my project to this thread!!!
Sub EstimateMatrixRun()
ScopeOfWorkSheetActivate
NumberingItems
DefineTask
TaskDescription
End Sub
Sub ScopeOfWorkSheetActivate()
Sheets("Scope Of work").Activate
End Sub
Sub NumberingItems()
If MsgBox("NEW ITEM", vbYesNo) = vbYes Then
'Determines next empty cell.
ItemNoEmptyCell = Application.WorksheetFunction.CountA(Range("B:B")) + 1
'Assigns consecutive numbers.
Cells(ItemNoEmptyCell, 1) = Application.WorksheetFunction.CountA(Range("B:B")) & Chr(46)
End If
End Sub
Sub DefineTask()
DEFINETASKUserForm.Show
End Sub
Sub TaskDescription()
Range("ScopeOfWork[TASK DESCRIPTION]") = _
[Index(Range("TaskDescription[TASK DESCRIPTION]"), Match(Range("ScopeOfWork"), Range("TaskDescription"), 0))]
End Sub
Bookmarks