Formulas to speed up many manual "=()" commands

[Cantab]

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

 

[JMB]

Can you set up a table w/pan numbers and their mass (let's say this table is
in A1:B4)

Pan Mass
1 0.5
2 0.65
3 0.8
4 1



Then in a column next to your data, use

=VLOOKUP(PanNumber, $A$1:$B$4, 2, FALSE)

where PanNumber is the cell reference containing the pan number used. Copy
the formula down as far as needed.

 

[Cantab]

Worked just how I had hoped. Just saved me a day or so of muckin
around. Thanks :