Hi
I am trying to use the Match formula but need it explained in laymans terms.
I have two tables of data and need to return a value by matching another.
i.e. Table 1 contains Account Number and a value, Table 2 contains Account number and I need it to contain the same value alongside the matching Account Number.Is this the best formula to use?
Many thanks
I am trying to use the Match formula but need it explained in laymans terms.
I have two tables of data and need to return a value by matching another.
i.e. Table 1 contains Account Number and a value, Table 2 contains Account number and I need it to contain the same value alongside the matching Account Number.Is this the best formula to use?
Many thanks