Appreciate your help.

I have set the spreadsheet and formulas up exactly as you have described
below but i am getting the following erroe reference in cell B2 worksheet 2-
#N/A.

Are you able to describe what each part of the formula refers to
specifically to help my understanding of it? Please could you break it down?

Thanks
--
RMP


"Pete_UK" wrote:

Assume your table with the account code and name is on Sheet1,
occupying A1 to B1000. Assume the other sheet is called Sheet2, and
has account code in column A and payment amount in column B.

First of all, insert a new column B in Sheet2, and enter this formula
in B2, assuming your data starts in A2 - maybe with a header row:

=VLOOKUP(A2,Sheet1!A$1:B$1000,2,0)

Adjust the ranges to suit your table. Copy this formula down column B
for as many items as you have in column A.

Hope this helps.

Pete

On Feb 24, 9:29 pm, RMP wrote:
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
--
RMP