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

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

Instruction: "In the main table in the cell under Cut Cost, enter a
formula using Lookup. This formula looks up the Cutting Cost in the
Cutting options table using the Gem cut and divides this value by the
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.


--
Beblessed
------------------------------------------------------------------------
Beblessed's Profile: http://www.excelforum.com/member.php...o&userid=32017
View this thread: http://www.excelforum.com/showthread...hreadid=517700