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. |
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 |