Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP: is there a compare function??
Hi there.
I would like some help in building a spreadsheet up.... what I would like to do is have 2 columns (A&B) Column A will be called CATALOG NUMBER Column B will be called PRODUCT FAMILY I would like to manually enter a catalog number in column A and have Excel to display the product family it belongs to automatically on column B. is it possible? how? I have between 10-15 product families (ie: screws, connectors, rawstock, etc) each product family has 5 to 20 possible combinations ("prefixes") - only the first 4 letters will define the product family, the rest will be a numeric secuencial code- for example the following numbers could be screws: ABCD001 ABCD099 ACBD001 ACBD099 CDBA234 etc... the following could be connectors (preffixes like XXZZ, XZXZ, XYZX) XXZZ001 XZXZ999 XYZX001 etc... Advice is needed, please help me complete this spreadsheet, I've used Excel only for its basic (and I mean really basic) functions. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP: is there a compare function??
Sure there is .. use a mixture of Lookup and left and get your result. I am going to assume your lookup table is A1:B50 (A1 and B1 are titles) =LOOKUP(LEFT(C1,4),$A$2:$A$50,$B$2:$B$50) -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=549077 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - need a function to compare lists | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |