I am after a way of using formulas replace manual "=()" commands in the
following situation...

I have 2 adjacent columns of data on one sheet that include a weighing
pan number and its corresponding mass. When entering the data of
weighed items, I just record the initial weigh pan number in the data
sheet. How would I insert the relevant weigh pan mass value for a given
item (from the initial 2 columns mentioned) in a column adjacent to, or
replacing the corresponding pan numbers in my new worksheet. I can do
this manually by using the "=()" command but it takes forever with a
big data set

This is complicated by using a particular boat multiple times, so
ranking both sets of data and subsequently copying columns will not
work.

Cheers


--
Cantab
------------------------------------------------------------------------
Cantab's Profile: http://www.excelforum.com/member.php...o&userid=37685
View this thread: http://www.excelforum.com/showthread...hreadid=572911