Need help on LOOKUP function..please

[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 formula I should type in, can you help me to add
formula on this 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.


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

 

[Biff]

Hi!

Hard to tell where all this stuff is (in a spreadsheet) but use this as your
guide:

=HLOOKUP(C6,B$2:C$3,2,0)

Biff

 

[Beblessed]

thank you so much Biff for your answer.
But as the 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.\"_
, I think we still need to add more on the formula to devides this
value by Carat. What formula should I add after
=HLOOKUP(C6,B$2:C$3,2,0)???

And could you explain what values this formula refer to? what does this
formula means??

Thank you again.

 

[Biff]

Hi!

It would be much easier (for us to understand) if you were to put that
sample in a spreadsheet file instead of a Word.doc file!

Biff

 

[Beblessed]

Thank you Biff, sorry I can't attach a spreadsheet file to this website.
So I added cell names in this new attached file, hope will make you
easier to understand.
Please check it out.

Thank you very much!!


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