retain calc from another cell after data sort
 

I have a cell that calcs off another cell. When I re-sort, I loose the calc.
I tried absolute and relative cell references and that did not work. How do
I link the two together so that the formula changes when the data is
re-sorted? I tried paste link that didnt work either. Any suggestions are
greatly appreciated.

retain calc from another cell after data sort
 

A1:A5 contains letters: A, B, C. D, E
B1:B5 contains numbers: 1,2,3,4,5
D1 has formula =2*B2 which returns 4.
Now I sort the range A1:B6 on column A in descending order and my formula
returns 8 since B2 now holds a 4
But if I use =VLOOKUP("B",A1:B5,FALSE)*2 then I always get 4 regardless of
how the data is sorted.
Any use? If not you need to tell us more about the data, its sorting and the
problem formula
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"levans" wrote in message
...
I have a cell that calcs off another cell. When I re-sort, I loose the
calc.
I tried absolute and relative cell references and that did not work. How
do
I link the two together so that the formula changes when the data is
re-sorted? I tried paste link that didnt work either. Any suggestions
are
greatly appreciated.