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

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

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

Cheer