I feel like this should be easy, but it is not working out for me so far. Basically, I have two worksheets, and I need to import data from the second spreadsheet when the two other columns match across worksheets.
Basic setup is this:
When the values in columns b and c match on both Spreadsheet 1 (SS1) and Spreadsheet 2 (SS2), I want to populate the value from column a on SS2 into column d on SS1. While columns b and c will match on both spreadsheets, they are not listed in the same order, so I need some type of array function to actually find the correct row on SS2.
Additional Info:
Not sure if it matters, but the values being referenced on SS1 (columns b and c) are contained within a pivot table
Thanks for the assistance
Basic setup is this:
When the values in columns b and c match on both Spreadsheet 1 (SS1) and Spreadsheet 2 (SS2), I want to populate the value from column a on SS2 into column d on SS1. While columns b and c will match on both spreadsheets, they are not listed in the same order, so I need some type of array function to actually find the correct row on SS2.
Additional Info:
Not sure if it matters, but the values being referenced on SS1 (columns b and c) are contained within a pivot table
Thanks for the assistance