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

sorry for the mess data detail, please see the attached file instead.


+-------------------------------------------------------------------+
|Filename: Gem Export company.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4403 |
+-------------------------------------------------------------------+

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