Hi,
I am trying to work out a formula without much luck so wondered if anyone could help please?
Basically, I have 2 work books one (request data) to feed from and another (request M.I) to report weekly. They are both in different folders.
So in Request Data I have -
Column A Column B
01.01.2012 170
02.01.2012 120
03.01.2012 132
etc
In a cell in the "Request M.I" workbook I would like to say, look in column A in the workbook "Request Data" find a specific date (which will be in a cell in Request M.I sheet- for instance C4) and report back the number in column b.
The If function won't seem to work with the range add I think it adds them all up.
I hope this makes sense. Any help would be very much appreciated!
I am trying to work out a formula without much luck so wondered if anyone could help please?
Basically, I have 2 work books one (request data) to feed from and another (request M.I) to report weekly. They are both in different folders.
So in Request Data I have -
Column A Column B
01.01.2012 170
02.01.2012 120
03.01.2012 132
etc
In a cell in the "Request M.I" workbook I would like to say, look in column A in the workbook "Request Data" find a specific date (which will be in a cell in Request M.I sheet- for instance C4) and report back the number in column b.
The If function won't seem to work with the range add I think it adds them all up.
I hope this makes sense. Any help would be very much appreciated!
