Getting data from another spreadsheet based on values in 2 columns
Posted on 2013-10-24
I am currently using this formula below to find the "last match" in the Cartography_12DEC2013_Oct21_Test.xlsm spreadsheet and populate Column N in the Book Production spreadsheet:
I am hoping to be able to modify this formula as follows:
1. Lookup $H$2:$H$675 on Cartography spreadsheet to find match(es) for value in column “M” in Book Production spreadsheet.
2. Then within the result from step 1, look up most recent initials/date stamp ( format is "RS 13 Oct 13") in column $AW$2:$AW$675 in Cartography spreadsheet.
3. From the row identified by Step 2, insert the value from Cartography $H$2:$H$675 column into column "N" in the Book Production spreadsheet.
I hope I've been able to express this clearly enough...don't hesitate to let me know if you have any questions...