Hello, I have two separate files. In one I have many sheets (one for each production lot) in which weekly evaluations are registered (I grade them from 1-5), for example:
File: Weekly Evaluations
Sheet: Lot 1
(Column A).................(Column B)........................(Column C)
Date......................... Condition........................... Productivity
02-nov-18..................... 1............................................ 4
I want to make a different excel file that will retrieve the last production evaluation that was registered. That way I have one synoptic view of all different production lots with their most recent evaluation, instead of having to look at each lot sheet individually in the Weekly Evaluations file.
File: Lot Overview
(Column A)
Date
=MAX('[Weekly Evaluations.xlsx]Lot 01'!$A:$A) (this is for retrieving the last registered evaluation in Lot 1)
(Column B)
Condition
=LOOKUPV(Table1[[#This row],[Date]],'Weekly Evaluations.xlsx'!Table1[#Data],2,FALSE)
The problem I am having is that even though I can get the last date that was registered in the Date column for the Lot Overview file, I cannot retrieve the input evaluation for "Condition" from the Weekly Evaluations file, and only get a "#N/A". I tried changing the date format in both files but it doesn't work.
(By the way I am translating the Excel formula names, so if something seems odd regarding this respect this is why).
I will appreciate the help.
Thanks,
File: Weekly Evaluations
Sheet: Lot 1
(Column A).................(Column B)........................(Column C)
Date......................... Condition........................... Productivity
02-nov-18..................... 1............................................ 4
I want to make a different excel file that will retrieve the last production evaluation that was registered. That way I have one synoptic view of all different production lots with their most recent evaluation, instead of having to look at each lot sheet individually in the Weekly Evaluations file.
File: Lot Overview
(Column A)
Date
=MAX('[Weekly Evaluations.xlsx]Lot 01'!$A:$A) (this is for retrieving the last registered evaluation in Lot 1)
(Column B)
Condition
=LOOKUPV(Table1[[#This row],[Date]],'Weekly Evaluations.xlsx'!Table1[#Data],2,FALSE)
The problem I am having is that even though I can get the last date that was registered in the Date column for the Lot Overview file, I cannot retrieve the input evaluation for "Condition" from the Weekly Evaluations file, and only get a "#N/A". I tried changing the date format in both files but it doesn't work.
(By the way I am translating the Excel formula names, so if something seems odd regarding this respect this is why).
I will appreciate the help.
Thanks,
