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