I have a large table of data in which I need to populate a certain
row. Here is an example.
Master table
Price
Nuts
Nuts
Bolts
Bolts
Bolts
Screws
Screws

Price Table
Nuts 1.00
Bolts .50
Screws .25

The price column in the master table is empty and I would like to fill
it in by referencing the price table. Does anyone know how I could do
this? Thanks.
Rory