R
RMP
Please could someone help me with look up tables.
I have 2 different worksheets within one spreadsheet. The one worksheet
contains an account number eg 00 00000 000 with an account name in the column
adjacent to the account number. The other shows just the account number and
payment amount. Is there any formula i could use which looks up the account
name from the one worksheet and adds the account name next to the number in
another worksheet?
I have thousands of entries to complete so any help at all would br brilliant.
Thanks
I have 2 different worksheets within one spreadsheet. The one worksheet
contains an account number eg 00 00000 000 with an account name in the column
adjacent to the account number. The other shows just the account number and
payment amount. Is there any formula i could use which looks up the account
name from the one worksheet and adds the account name next to the number in
another worksheet?
I have thousands of entries to complete so any help at all would br brilliant.
Thanks