| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Return a value for a known code
I am trying to return a value for a code of mixed characters from a list of a possible 250 codes. I want to identify potentialy 30 of those codes and return a value dependant upon that code. For example
Code Value BT 3 KA27 2 KA28 2 PH 2 E1-6 5 SE1-8 5 BA 1 or blank TA 1 or blank I have tried using "IF" but can only use a max of 7 arguments, I don't want to have to list every code in a table to apply the VLOOKUP. Is there a simply solution? Your help would be much appreciated. Many thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return a value for a known code
Look in the help index for VLOOKUP
-- Don Guillett Microsoft MVP Excel SalesAid Software "Bosser" wrote in message ... I am trying to return a value for a code of mixed characters from a list of a possible 250 codes. I want to identify potentialy 30 of those codes and return a value dependant upon that code. For example Code Value BT 3 KA27 2 KA28 2 PH 2 E1-6 5 SE1-8 5 BA 1 or blank TA 1 or blank I have tried using "IF" but can only use a max of 7 arguments, I don't want to have to list every code in a table to apply the VLOOKUP. Is there a simply solution? Your help would be much appreciated. Many thanks. -- Bosser |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enhance sumproduct to return unique employee code count | Excel Worksheet Functions | |||
| Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
| How to return the Number of shares for a given stock code for a given portfolio | Excel Discussion (Misc queries) | |||
| How can I control the length of characters a code will return? | Excel Discussion (Misc queries) | |||
| carriage return code | Setting up and Configuration of Excel | |||
Hybrid Mode
