Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there a function, if cell1=Text then cell2=#? Excel 03
I'm trying to create a database style sheet for doing quotes. I have a list
of products in one cell, and want different prices to appear in another cell depending on what is listed in cell one. Is this possible? Seems like it should be |
#2
|
|||
|
|||
Hi A
I'm sure it's possibel, but a bit more information is needed! Please post back with what you have and what you are trying to achieve. I would guess you'll need to set up a table and use VLOOKUP to retrieve the various figures you want. Andy. <A wrote in message ... I'm trying to create a database style sheet for doing quotes. I have a list of products in one cell, and want different prices to appear in another cell depending on what is listed in cell one. Is this possible? Seems like it should be |
#3
|
|||
|
|||
I have a list of about 50 different stone names. Each one is associated with
a different level (numbered 1-4). For each level there is a different price (valued $52-85). I want to pull up 1 of the 50 names and have the price level and price shown in the cell. I was starting to get somewhere with this formula, =IF(B10=Tan_Brown,2,0)etc..., this was giving me the number of one of the 50 stones and then a corresponding formula in another cell would give me the price dependant upon a 2 showing up in the first cell. However, I have been unsuccessful with the entry of the other 49 stones. Confused? So am I "Andy" wrote: Hi A I'm sure it's possibel, but a bit more information is needed! Please post back with what you have and what you are trying to achieve. I would guess you'll need to set up a table and use VLOOKUP to retrieve the various figures you want. Andy. <A wrote in message ... I'm trying to create a database style sheet for doing quotes. I have a list of products in one cell, and want different prices to appear in another cell depending on what is listed in cell one. Is this possible? Seems like it should be |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |