P
Philip
Hi,
I have this to find the row of data in another workbook:
=MATCH(A5,'T:\Excel\ABM Amro Expenses\Expenses\NAV ALERT\EXPORT
ARCHIVE\SICAV\20040816\[ExportXXXX.xls]Export'!$A$9:$A$93,0)
where the XXXX is a fund like IK05 or MMAF...
What I need is something like this:
=MATCH(A5,"'" & DirectoryPath & DateFolder & "[Export" & Fund &
".xls]Export'!" & "$A$9:$A$93",0)
Is that possible, and how can I do this?
thanks for any adviece or assistance
Philip
I have this to find the row of data in another workbook:
=MATCH(A5,'T:\Excel\ABM Amro Expenses\Expenses\NAV ALERT\EXPORT
ARCHIVE\SICAV\20040816\[ExportXXXX.xls]Export'!$A$9:$A$93,0)
where the XXXX is a fund like IK05 or MMAF...
What I need is something like this:
=MATCH(A5,"'" & DirectoryPath & DateFolder & "[Export" & Fund &
".xls]Export'!" & "$A$9:$A$93",0)
Is that possible, and how can I do this?
thanks for any adviece or assistance
Philip