Don't understand Lookup function

[Beblessed]

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]

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."

Please see the attached file for data details.

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

Thank you.