ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Return a value for a known code (https://www.excelbanter.com/excel-worksheet-functions/177648-return-value-known-code.html)

Bosser

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.


All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com