If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Don't understand Lookup function
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 |
#2
|
|||
|
|||
Don't understand Lookup function
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
determine if Excel is open | geebee | General Discussion | 11 | January 20th, 2006 09:25 PM |
How to modify function | Kevin | General Discussion | 5 | January 4th, 2006 10:12 PM |
SPELL CURRENCY FUNCTION | Rajesh | Using Forms | 1 | October 1st, 2005 11:04 PM |
Attaching Code | DS | General Discussion | 2 | August 22nd, 2005 11:21 PM |
Need a ISWorkday Function -- Any Ideas | Mark | Worksheet Functions | 5 | March 29th, 2005 01:58 AM |