Using two excel sheets

[Bdozer]

Hi,
I would like to retrieve information from my VA 2014 excel sheet to use on my July 2017 P & L excel sheet.
Column L on the VA 2014 contains dates and Column M contains currency.
I would like to retrieve from 07/01/2017 through 07/31/2017 in column L and then add the currency in column M.

I believe the start should be, =IF('[VA 2014.xlsx]2017'!$L:$L

This is where I can't figure out how to command it to get just the July dates and then add, '[VA 2014.xlsx]2017'!$M:$M))

Any help would be appreciated.

Thanks,

[Aardigspook]

Without seeing sample file(s) it's difficult to be sure, but you probably want something like this:

Please Login or Register  to view this content.

It's an array formula, so enter it using Ctrl-Shift-Enter, not just Enter. You should see curly brackets {} appear round your formula (don't try to enter them yourself).

To get the values from column M, replace the first range $L$2:$L$100 with $M$2:$M$100:

Please Login or Register  to view this content.

Drag the formulae down as far as you need.

Array formulae can slow down your file quite a bit if the range they're trying to index is too large, which is why I've limited the range to just rows 2:100 instead of the whole column L:L (or M:M). Obviously, I hope, if your data is in a lot more rows, then just increase the range ($L$2:$L$1500 for example).
If your data in the VA 2014 file doesn't start on row 2, then you'll need to adjust the formulae slightly. Before the ROW(1:1) part, there's a -1. That number needs to be whatever the result of 'row 1 - starting row number' is (so if your data starts on row 3, it would be 1-3 so -2.

Hope that helps (and makes sense ).