I am using the following formula to copy data from another worksheet into my current worksheet. It worked fine since I only had the 2014 worksheet/log to look up the data. But now I need to use the 2015 log to look up in addition to the 2014 log. How do I change this so that I can get the date from BOTH the 2014 sheet AND the 2015 sheet? So if it the data is not in the 2015 log, then I need the data from the 2014 log, and if the data is not in either log, then the cell remains empty/blank.

=IF(ISNA(VLOOKUP(B22,'W:\RA Log\[2014 New Entered & Received - Daily Tracking.xlsx]Received RAs & T&E Tracking'!A$2:P$1000000,4,FALSE))," ",VLOOKUP(B22,'W:\RA Log\[2014 New Entered & Received - Daily Tracking.xlsx]Received RAs & T&E Tracking'!A$2:P$1000000,4,FALSE))

Thanks as always!!!