L
Legacy 57334
Guest
Really need some help. Ive reached the end of my knowledge. I've managed to create a formula that will compare the data in a table of data with second table of data, and copy data from table2 to table1 if it finds that enough data matches. It works fine if the match is on the same row.
In the example below, table1 in green and table2 is orange. You can see the formula in the screenshot too.
What i need is for the formula to look for a match not just on the same row, but in all rows of the orange table, one by one, until it finds a match, or reaches the end of the table without a match.
How do i do that?
thank you
Joel
In the example below, table1 in green and table2 is orange. You can see the formula in the screenshot too.
What i need is for the formula to look for a match not just on the same row, but in all rows of the orange table, one by one, until it finds a match, or reaches the end of the table without a match.
How do i do that?
thank you
Joel