software

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 quot;Lookupquot; 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:
_\quot;In_the_main_table_in_the_cell_under_Cut_Cost,_e nter_a_formula_using_Lookup._This_formula_looks_up _the_Cutting_Cost_in_the_Cutting_options_table_usi ng_the_Gem_cut_and_divides_this_value_by_the_Carat .\quot;_
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: www.excelforum.com/attachment.php?postid=4406 |
-------------------------------------------------------------------

--
Beblessed
------------------------------------------------------------------------
Beblessed's Profile: www.excelforum.com/member.php...oamp;userid=32017
View this thread: www.excelforum.com/showthread...hreadid=518089Hi!

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

quot;Beblessedquot; gt; wrote in
message ...
gt;
gt; I'm doing revision of my exam and I don't understand about Lookup
gt; function, what's this function for??
gt;
gt; When I read the instruction aboout quot;Lookupquot; on my revised exam paper, I
gt; don't know what the formula I should type in, can you help me to add
gt; formula on this data.(About Gem company)
gt;
gt; Instruction:
gt; _\quot;In_the_main_table_in_the_cell_under_Cut_Cost,_e nter_a_formula_using_Lookup._This_formula_looks_up _the_Cutting_Cost_in_the_Cutting_options_table_usi ng_the_Gem_cut_and_divides_this_value_by_the_Carat .\quot;_
gt;
gt; Please see the attached file for data details.
gt;
gt; What the formula do I have to put in the cell under Cut Cost?
gt;
gt; Thank you.
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: Gem Export company.doc |
gt; |Download: www.excelforum.com/attachment.php?postid=4406 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; Beblessed
gt; ------------------------------------------------------------------------
gt; Beblessed's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32017
gt; View this thread: www.excelforum.com/showthread...hreadid=518089
gt;

thank you so much Biff for your answer.
But as the instruction quot;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.\quot;_
, 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.--
Beblessed
------------------------------------------------------------------------
Beblessed's Profile: www.excelforum.com/member.php...oamp;userid=32017
View this thread: www.excelforum.com/showthread...hreadid=518089Hi!

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

quot;Beblessedquot; gt; wrote
in message ...
gt;
gt; thank you so much Biff for your answer.
gt; But as the instruction quot;In the main table in the cell under Cut Cost,
gt; enter a formula using Lookup. This formula looks up the Cutting Cost in
gt; the Cutting options table using the Gem cut and
gt; _divides_this_value_by_the_Carat.\quot;_
gt; , I think we still need to add more on the formula to devides this
gt; value by Carat. What formula should I add after
gt; =HLOOKUP(C6,B$2:C$3,2,0)???
gt;
gt; And could you explain what values this formula refer to? what does this
gt; formula means??
gt;
gt; Thank you again.
gt;
gt;
gt; --
gt; Beblessed
gt; ------------------------------------------------------------------------
gt; Beblessed's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32017
gt; View this thread: www.excelforum.com/showthread...hreadid=518089
gt;

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: www.excelforum.com/attachment.php?postid=4412 |
-------------------------------------------------------------------

--
Beblessed
------------------------------------------------------------------------
Beblessed's Profile: www.excelforum.com/member.php...oamp;userid=32017
View this thread: www.excelforum.com/showthread...hreadid=518089