Hello,
I am open to how I solve this. The issue is I have one sheet in a workbook that contains the lookup value to another sheet.
In the other sheet, I have added a column to try to resolve - but to no avail.
The other sheet has 3 Columns - Column A - US Lifecycle ,Column B - Canada Lifecycle, and Column C - Puerto Rico Lifecycle. These contain the numbers I want to return. on my first sheet. To match these, I am matching the lookup from the first sheet to another column G on this second sheet. *IN a lot of instances, G will have the same number on different rows (up to 3 times). For these instances, I need to capture the lookup value and return the correct number of the lifecycle columns to my first sheet. The issue seems to be that excel sees the first row in the column, and then stops at the row; even though there may or may not be additional rows that hold another match column G with my number on the first sheet and then returns whichever value in A, B, C that I looked up first. So sometimes, I am getting blanks because the formula stopped at the first match.
In the added column K - I have US, PR, CA all in the same column as values. I thought maybe if I cannot have it loop through every cell, I could throw another catch for each lifecycle column.
Bookmarks