Hello,
I have two Excel tables. What I would like to do is keep rows where column 1 from table 1 matches with column 1 in table 2 then feed those rows into an array. Please see below.
Table 1:
Table 2:
So here row 3 in table 1 matches with row 9 in table 2 as they both have 'a' in the Name Column so the row would be taken from table 2 - the outcome is below:
Please advise on how I would achieve this cheers

Report
All responses (
Answers (