Index & Match VBA Code

[OcMac]

Hey all,

I knew this would be a big undertaking when I took it on, but I have to try and figure this out. I am only on the first part of this which is to pull back the TD name. I figure if I could get that part working first then I could get the rest of it. But I am running into a Type 13, file mistype error in the line that starts strTDName = Application.... and I am not sure why. I think it might have to do with my ranges I have named? Anyway, here is what I have for code, any help would be great. Just spent 10 hours on it today and not moved forward, keep reading sites and not finding what I am looking for.

Please Login or Register  to view this content.

[venkat1926]

how can I check whatever code I write in the absence of your data sheet. however try or tweak this code
[c0de]
strTDName="=index(" & rnTDusa & "," & "match(" & strcode & strdeparture & "," & "," & rtdusacode & rngtdusdeparture & ,0),10)" & """"
[/code]
i cannot est because whats rntdus etc

[OcMac]

Thank you for your help, but that is not working for me either.

Maybe this is a better way of doing this, here is the nutshell version of what I am trying to do.

In Workbook A, I want to take the data in column A & Column B and goto workbook B and match up the data of Column A and Column B and pull back the data in Column C of Workbook B to Workbook A in column C.