Sorting in Excel spreadsheets

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I have a worksheet with codes, decodes and other data
which links the codes to column A in a second sheet (and
other places). The second sheet then has data entered
against these codes. When I add more codes to the first
sheet and sort again the column of codes in the second
sheet also moves which is what I want. BUT ... I also
want the data alongside those codes in the second sheet
to move with them and it doesn't. How can I get this to
happen? CAN ANYONE OUT THERE HELP ME PLEASE?
 
Hi Brian
you may use VLOOKUP in the other columns on sheet 2. e.g. enter the
following in B1 on the second sheet:
=VLOOKUP('sheet1'!$A$1:$B$1000,2,0)

this will get the corresponding value from column B of sheet 1.
Note: This will work only, if column A contains unique values
 
I'm not sure if I understand completely, but I do know that using a dollar sign in front of a cell will lock that cell in a formula
Example: A1 should be written as $a$1. Then it will not change when other things do.
 
Back
Top