When I reference a cell in a separate list, I am unable to sort thatlist and keep the reference. Any

  • Thread starter Thread starter Mike C
  • Start date Start date
M

Mike C

I have noticed that when I reference a cell (eg, in worksheet 1) from
a list (eg, in Worksheet 2) in another spreadsheet, and then sort the
list (in Worksheet 2), that I lose me reference (in worksheet 1). Does
anyone know how I can alter the reference, or user settings so that I
can avoid this problem?

Thanks for any suggestions!
 
Hi Mike

Instead of pointing to the cell in the second sheet, can you make the entry
a Vlookup of some value from the other sheet.
Then it will find the correct value, even after sorting.
For example, if column A of Sheet1 had Names, and column B was using your
existing reference to find a value belonging to that Name from Sheet2, you
could use
=VLOOKUP(A2,Sheet2!$A:$B,2,0)
 
Hi Mike

Instead of pointing to the cell in the second sheet, can you make the entry
a Vlookup of some value from the other sheet.
Then it will find the correct value, even after sorting.
For example, if column A of Sheet1 had Names, and column B was using your
existing reference to find a value belonging to that Name from Sheet2, you
could use
=VLOOKUP(A2,Sheet2!$A:$B,2,0)

--
Regards
Roger Govier







- Show quoted text -
Click to expand...

Ok, thanks Roger. I should have thought of that. I will give it a
shot.
 
Back
Top