Don't understand Lookup function

  • Thread starter Thread starter Beblessed
  • Start date Start date
B

Beblessed

I'm doing revision of my exam and I don't understand about Looku
function, what's this function for??

When I read the instruction aboout "Lookup" on my revised exam paper,
don't know what the function I should type in, can you help me to ad
function on th following data.(About Gem company)

Instruction: "In the main table in the cell under Cut Cost, enter
formula using Lookup. This formula looks up the Cutting Cost in th
Cutting options table using the Gem cut and divides this value by th
Carat."

_cutting_option_
Gem cut cabochons faceted
Cutting cost 5 10

_Name _Precious _Gem_cut __Carat__Carat_Value__Cut_cost__Total_value___
Amethyst sp faceted 17.9 5 116.35
Citrine sp faceted 18.88 12 254.88
Diamond p faceted 0.29 862 250.705
Emerald p cabochons 0.42 357 150.99

What the formula do I have to put in the cell under Cut Cost?

Thank you
 
Back
Top