twolfs4life
New Member
- Joined
- Feb 27, 2014
- Messages
- 2
Hi everyone,
New to this forum, but had an Excel issue I was running into and wanted some feedback from the gurus. I have an Excel file (A) that has a key identifier as the first column (Column A) and the specific month/yr on it as the second column (Column B) and I want to match this file with a very large Excel file (B) that has various key identifiers as the first column (Column A) and the month/yr across the top as the first row (Row 1).
Inside Excel file (B) there are many numbers in there. Want I want to do is write a formula in Excel file (A) that tells me based on the key identifier and month/yr to find the same key identifier and month/yr in Excel file (B) --> index/match/match I would imagine BUT then tell me if there are values before that month/yr or after that month/yr and which month/yr if before.
For example Excel file (A) the key id is ABC123 and the month/yr is May 2013. I write formula that finds item ABC123 and month/yr May 2013 in the Excel file (B) and then tells me that there are values in February 2013 and August 2013.
Anyone help would be appreciated. Spinning my wheels on this one. Thanks!
New to this forum, but had an Excel issue I was running into and wanted some feedback from the gurus. I have an Excel file (A) that has a key identifier as the first column (Column A) and the specific month/yr on it as the second column (Column B) and I want to match this file with a very large Excel file (B) that has various key identifiers as the first column (Column A) and the month/yr across the top as the first row (Row 1).
Inside Excel file (B) there are many numbers in there. Want I want to do is write a formula in Excel file (A) that tells me based on the key identifier and month/yr to find the same key identifier and month/yr in Excel file (B) --> index/match/match I would imagine BUT then tell me if there are values before that month/yr or after that month/yr and which month/yr if before.
For example Excel file (A) the key id is ABC123 and the month/yr is May 2013. I write formula that finds item ABC123 and month/yr May 2013 in the Excel file (B) and then tells me that there are values in February 2013 and August 2013.
Anyone help would be appreciated. Spinning my wheels on this one. Thanks!
