Living The Promise Vintage Jewelry

Here are Todays Amazing Faceted Cut Deals

More Great Information on Faceted Cut:

Color Gift Glasses of Artel by Prabhu

Artel creates that favorite of Central European nobles for the past several hundred years, Bohemian crystal. Updated designs by the young American entrepreneur Karen Feldman turn out unusual vases, glasses, and tumblers that are regularly stocked by aspirational retailers such as Paul Smith, Fortnum & Mason, and Scully & Scully. Although plans are in the works for Artel's own Prague store to open in 2007, the current collection is available to view at the Vinohradska location in Vinohrady by appointment only.

Wiseman has now teamed up with famed glass designer and manufacturer artel to create the glacier collection a series of cut glass vessels that experiment with faceting and different textures. each piece is handcut by artel’s czech artisans and contrasts smooth polished surfaces with rougher faceted edges. you can click here to find out more about Artel and you can find more on wiseman right here.

Clean lines of the opalescent crystal decanter set are inspired by a playful beehive figure. The traditional Czech design is realized by master craftsmen in Prague, resulting in a whimsical way to attain maximum satisfaction from your liqueurs and spirits. Piece consists of three layers of glass which are blown together and then cut and polished by hand into18 facets, making for deep hues that vary according to the angle of viewing. The faceted bowl and plate mark a departure for Artel, which until now has specialized in glassware engraved by hand. Please purchase on online www.etabletop.com

Representing Artel Glasses in the website www.etabletop.com

Article Source: http://www.earticlesonline.com/Article/Color-Gift-Glasses-of-Artel/305212

plz it is urgent ! it is about MS EXCEL and i am stuck on this question?

the question is:
Enter a formula in cut cost using LOOKUP from cutting cost in the cutting option using gem cut and the value divides by carat.
the table is given as under:
Cutting Options
Gem Cut...........Cabochons Faceted
Cutting Cost........... 5..................10

Name Precious Gemcut Carat CaratValue CutCost Insurance

*these are the columns and the last column which i cud not enter becoz of space is Totalvalue.

now i have to use the lookup function to get the value of cutcost which should b equal to cutting cost according to the gemcut divided by carat .
plz help me
i need the answer ASAP
w8ing for answers
desperately

In the help section, type lookup function

The screen that comes up would not copy correctly to Answers. It is formatted in columns and much better to understand on the Excel screen!But, here is the best that I could do for you.:

LOOKUP
Returns a value either from a one-row or one-column range or from an array (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.). The LOOKUP function has two syntax forms: the vector form and the array form.If you want to Then see Usage
Look in a one-row or one-column range (known as a vector) for a value and return a value from the same position in a second one-row or one-column range Vector form Use the vector form when you have a large list of values to look up or when the values may change over time.
Look in the first row or column of an array for the specified value and return a value from the same position in the last row or column of the array Array form Use the array form when you have a small list of values and the values remain constant over time.

Note You can also use the LOOKUP function as an alternative the IF function for elaborate tests or tests for more than seven conditions. See the examples in the array form.

--------------------------------------------------------------------------------

Vector form
A vector is a range of only one row or one column. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range. Use this form of the LOOKUP function when you want to specify the range that contains the values that you want to match. The other form of LOOKUP automatically looks in the first column or row.

LOOKUP(lookup_value,lookup_vector,result_vector)

Lookup_value A value that LOOKUP searches for in the first vector. Lookup_value can be a number, text, a logical value, or a name or reference that refers to a value.

Lookup_vector A range that contains only one row or one column. The values in lookup_vector can be text, numbers, or logical values.

Important The values in lookup_vector must be placed in ascending order: ...,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP may not give the correct value. Uppercase and lowercase text are equivalent.

Result_vector A range that contains only one row or column. It must be the same size as lookup_vector.

Remarks

If LOOKUP can't find the lookup_value, it matches the largest value in lookup_vector that is less than or equal to lookup_value.
If lookup_value is smaller than the smallest value in lookup_vector, LOOKUP gives the #N/A error value.
Example

The example may be easier to understand if you copy it to a blank worksheet.

How to copy an example

Create a blank workbook or worksheet.
Select the example in the Help topic.
Note Do not select the row or column headers.

Selecting an example from Help

Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

1
2
3
4
5
6
A B
Frequency Color
4.14 red
4.19 orange
5.17 yellow
5.77 green
6.39 blue
Formula Description (Result)
=LOOKUP(4.19,A2:A6,B2:B6) Looks up 4.19 in column A, and returns the value from column B that's in the same row (orange)
=LOOKUP(5.00,A2:A6,B2:B6) Looks up 5.00 in column A, matches the next smallest value (4.19), and returns the value from column B that's in the same row (orange)
=LOOKUP(7.66,A2:A6,B2:B6) Looks up 7.66 in column A, matches the next smallest value (6.39), and returns the value from column B that's in the same row (blue)
=LOOKUP(0,A2:A6,B2:B6) Looks up 0 in column A, and returns an error because 0 is less than the smallest value in the lookup_vector A2:A7 (#N/A)

--------------------------------------------------------------------------------

Array form
The array form of LOOKUP looks in the first row or column of an array (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) for the specified value and returns a value from the same position in the last row or column of the array. Use this form of LOOKUP when the values that you want to match are in the first row or column of the array. Use the other form of LOOKUP when you want to specify the location of the column or row.

Tip In general, it's best to use the HLOOKUP or VLOOKUP function instead of the array form of LOOKUP. This form of LOOKUP is provided for compatibility with other spreadsheet programs.

LOOKUP(lookup_value,array)

Lookup_value A value that LOOKUP searches for in an array. Lookup_value can be a number, text, a logical value, or a name or reference that refers to a value.

If LOOKUP can't find the lookup_value, it uses the largest value in the array that is less than or equal to lookup_value.

If lookup_value is smaller than the smallest value in the first row or column (depending on the array dimensions), LOOKUP returns the #N/A error value.

Array A range of cells that contains text, numbers, or logical values that you want to compare with lookup_value.

The array form of LOOKUP is very similar to the HLOOKUP and VLOOKUP functions. The difference is that HLOOKUP searches for lookup_value in the first row, VLOOKUP searches in the first column, and LOOKUP searches according to the dimensions of array.

If array covers an area that is wider than it is tall (more columns than rows), LOOKUP searches for lookup_value in the first row.

If array is square or is taller than it is wide (more rows than columns), LOOKUP searches in the first column.

With HLOOKUP and VLOOKUP, you can index down or across, but LOOKUP always selects the last value in the row or column.

Important The values in array must be placed in ascending order: ...,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP may not give the correct value. Uppercase and lowercase text are equivalent.

Example 1
The example may be easier to understand if you copy it to a blank worksheet.

How to copy an example

Create a blank workbook or worksheet.
Select the example in the Help topic.
Note Do not select the row or column headers.

Selecting an example from Help

Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

1
A B
Formula Description (Result)
=LOOKUP("C",{"a","b","c","d";1,2,3,4}) Looks up "C" in the first row of the array, finds the largest value that is less than or equal to it ("c"), and then returns the value in the last row that's in the same column (3)
=LOOKUP("bump",{"a",1;"b",2;"c",3}) Looks up "bump" in the first row of the array, finds the largest value that is less than or equal to it ("b"), and then returns the value in the last column that's in the same row (2)

Example 2
The example may be easier to understand if you copy it to a blank worksheet.

How to copy an example

Create a blank workbook or worksheet.
Select the example in the Help topic.
Note Do not select the row or column headers.

Selecting an example from Help

Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.
The following example uses an array of numbers to assign a letter grade to a test score.

1
2
3
4
A
Score
45
90
78
Formula Description (Result)
=LOOKUP(A2,{0,60,70,80,90},{"F","D","C","B","A"}) Looks up the value in A2 (45) in the first row of the array, finds the largest value that is less than or equal to it (60), and then returns the value in the last row of the array that's in the same column (F)
=LOOKUP(A3,{0,60,70,80,90},{"F","D","C","B","A"}) Looks up the value in A3 (90) in the first row of the array, finds the largest value that is less than or equal to it (90), and then returns the value in the last row of the array that's in the same column (A)
=LOOKUP(A4,{0,60,70,80,90},{"F","D","C","B","A"}) Looks up the value in A4 (78) in the first row of the array, finds the largest value that is less than or equal to it (80), and then returns the value in the last row of the array that's in the same column (C)
=LOOKUP(A2,{0,60,63,67,70,73,77,80,83,87,90,93,97},{"F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"}) Looks up the value in A2 (45) in the first row of the array, finds the largest value that is less than or equal to it (60), and then returns the value in the last row of the array that's in the same column (F)
=LOOKUP(A3,{0,60,63,67,70,73,77,80,83,87,90,93,97},{"F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"}) Looks up the value in A3 (90) in the first row of the array, finds the largest value that is less than or equal to it (90), and then returns the value in the last row that's in the same column (A-)
=LOOKUP(A4,{0,60,63,67,70,73,77,80,83,87,90,93,97},{"F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"}) Looks up the value in A4 (78) in the first row of the array, finds the largest value that is less than or equal to it (80), and then returns the value in the last row that's in the same column (C+)