Hello.
I have the following
TABLE 1
Column A Column B Red Today Blue Tomorrow Yellow Yesterday
Then I have another table under this one which is the following
TABLE 2
Column A Column B Yellow Red Blue
As you can see values in Table 2 - Column A are in a different order than values in Table 2 - Column A
What I want is that when values in Table 2 - Column A that match Values of Table 1 - Column A, Then the formula has to copy in Table 2 - Column B the correspondent value that was in Table 1 - Column B.
Basically, the result has to be this one:
Column A Column B Yellow Yesterday Red Today Blue Tomorrow
Thanks
Bookmarks