help with cell reference

  • Thread starter Thread starter Dumb_Question
  • Start date Start date
D

Dumb_Question

hI!

i need some help in linking 2 cells.
here is the scenario:
I want to make reference of cells in a particular column on Sheet I
to a certain column in Sheet!. But the thing is that sheet II has
buttons that are assigned to 4 sort macros. When the list is sorted b
different macros, the cell location in the column changes and i
affects the formulas in sheet 2.

How can fix this?

i will appreciate your help
 
Instead of referencing a specific cell, you could use a lookup function
to find the correct value. For example, to find the tax rate for a province:

=VLOOKUP("Ontario",Data!$B$2:$C$12,2,0)

Even if the list is sorted in a different order, the correct value will
be returned.
 
vlookup is good as debra suggested. but has it's drawbacks.

1) wether using the functions inherent qualities to find exact o
'approximate' match, it doesn't bode well with more than one qualifie
in the specified column.

2) (just a side note) when sorting data, just remember to sort all dat
- expanding selection - so it's still in order.

sorry to barge in, HTH

-zac
 
Back
Top