Index/Match with mulitple arrays

Hi Everyone,

I am ready to pull my hair out. I have worked on this for hours as I am very new to the VBA world.

I have two issues that I am trying to solve, but will stick with just this one for now.

I am working an Index/Match and they both have two formulaarrays. I am working in one workbook and need to match cells from another workbook pulling from two worksheets in that work book and return those values from the two worksheets into the current workbook.
I cannot get them to work. Here is what I have put together so far:


rng.FormulaArray = "=(Index([889D_FNS.XLS]'Payables608'!$D$2:$D$300&'UndeliveredOrders608'!D$2:D$300,Match(B4:B300,[889D_FNS.XLS]'Payables608'!D$2:D$300.ADDRESS(FALSE,FALSE)&'UndeliveredOrders608'!D$2:D$300.ADDRESS(FALSE,FALSE,0))"

Anything you can do to help me would be greatly appreciated.

Thank you,
Jeannie

Thank you for replying, but it is now giving me the error message 91, "Object variable or with block variable not set?

rng.FormulaArray = "=(Index([889D_FNS.XLS]'Payables608'!$D$2:$D$300&'UndeliveredOrders608'!$D$2$300,Match(B4:b300,[889D_FNS.XLS]'Payables608'!D$2:D$300&'UndeliveredOrders608'!D$2:D$300,0))"

I took out the .Address(FALSE,FALSE).

Could my DIM be in the wrong place:

Sub OpenObligations()

Dim rng As Range

'
' OpenObligations Macro
'
' Keyboard Shortcut: Ctrl+r
'

Worksheets("1358").Range("A1:AA600").Clear
Worksheets("2237").Range("A1:AA600").Clear

I see there have been several who have read my post and I have not seen any responses so I figured maybe I should try another change to my macro. I also thought maybe it has something to do with the cells I was trying to read had a formula already in it so I created another column without the formula.

I have changed to the following and now get the error message, "Unable to set the FormulaArray property of the range class," Error 1004:

ActiveCell.FormulaArray = "=(Index([889D_FNS.XLSx]'Payables608'!$e$2:$e$300&'UndeliveredOrders608'!$e$2$e$300,Match(B4:B300,[889D_FNS.XLSx]'Payables608'!e$2:e$300&'UndeliveredOrders608'!e$2:e$300,0)))"