Worksheet Formula Issues

[Smirlface]

I have two worksheets (let's call them a & b) that my accounting program
dumps into excel. They are identical with around 1000 rows of info. Column A
has the title, and Column B has a figure.

I want to link the cells in worksheet 'b' to worksheet 'a' so
data changed in Column B in worksheet 'a' will show in the same cell in
worksheet 'b'.

However, I need to rearrange the rows in worksheet 'a' to be in a format
that my accountant can read, but worksheet 'b' will remain the same as I need
to upload it back into the accounting system.

What do I have to do to make sure the two worksheets are linked properly to
the
correct cells once worksheet 'a' is rearranged?

 

[Jacob Skaria]

Take a look at the worksheet function VLOOKUP()

Suppose you have the sheets named as Sheet1 and Sheet2. In sheet2 cell B1
apply the below formula and copy down as required..

=VLOOKUP(A1,Sheet1!A:B,2,0)

 

[Smirlface]

Hi Jacob,

I'm not really familiar with VLOOKUP, so when I tried entering in the
formula, it didn't work. I'll go into more detail about the workbook i have:

A B C D
E F
NAME Account Code Account Type Period 1 Period 2 Period 3
jbloggs ASD ID 1000 100
1000
andsoon ASR ID 110 100
100

What will my VLOOKUP formula be? the current one I have always brings up a
#REF error.

Thanks,

 

[Smirlface]

Thank you, I just figured out the reason why my formula wasn't working. It
was because of the name of the file for some reason.