Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup function
I have a lookup function question
Column AC will have one of the following disposal codes (disposal site) (PB, EP, BL, HI, VA, MA etc) Each of those Codes has a different $ value I need to know if there is a way to have a cell calculate a different value based on the Code that is column AC. Basically we are trying to find the most profitable disposal site -- Barb |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup function
Can you elaborate a bit? Where is the $ value for those codes, in a column
next to the codes column? What do you mean by have a cell calculate a different value? "B G" wrote: I have a lookup function question Column AC will have one of the following disposal codes (disposal site) (PB, EP, BL, HI, VA, MA etc) Each of those Codes has a different $ value I need to know if there is a way to have a cell calculate a different value based on the Code that is column AC. Basically we are trying to find the most profitable disposal site -- Barb |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup function
Probably you might be looking for something like this:
Assuming quantity figs are running down in AA2, Then in say, AD2: =IF(AA2="","",AA2*VLOOKUP(AC2,{"PB",1;"EP",2;"BL", 5;"HI",8},2,0)) where the VLOOKUP's table_array: {"PB",1;"EP",2;"BL",5;"HI",8} would house the ref/unit numeric $values associated with the codes in col AC AD2 could then be copied down to return correspondingly .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "B G" wrote: I have a lookup function question Column AC will have one of the following disposal codes (disposal site) (PB, EP, BL, HI, VA, MA etc) Each of those Codes has a different $ value I need to know if there is a way to have a cell calculate a different value based on the Code that is column AC. Basically we are trying to find the most profitable disposal site -- Barb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numerical integration | Excel Discussion (Misc queries) | |||
Lookup Function help | Excel Discussion (Misc queries) | |||
Lookup Function Problems | Excel Worksheet Functions | |||
lookup function 1 | Excel Worksheet Functions | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions |