Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using search function to classify data
Dear Helpers,
Via e-banking service, I have extracted my current account data to control my business. From the data, I use the following formula to classify the payment types based on the transaction description. =IF(OR((ISNUMBER(SEARCH("AAW",C5697))),(ISNUMBER(S EARCH("ABT",C5697)))),VALUE(RIGHT(C5697,7)),IF(ISN UMBER(SEARCH("Rental",C5697)),RIGHT(C5697,8),IF(OR ((ISNUMBER(SEARCH("ABC",C5697))),(ISNUMBER(SEARCH( "ABB",C5697))),(ISNUMBER(SEARCH("AAC",C5697))),(IS NUMBER(SEARCH("CH",C5697))),(ISNUMBER(SEARCH("TAX" ,C5697))),(ISNUMBER(SEARCH("GD",C5697)))),"EXPENSE ",IF(OR(ISNUMBER(SEARCH("CASH",C5697)),ISNUMBER(SE ARCH("-",C5697))),"DEPOSIT",IF(OR((ISNUMBER(SEARCH("12345 67",C5697))),(ISNUMBER(SEARCH("23456789",C5697))), (ISNUMBER(C5697))),C5697,"TRANSFER"))))) As the description changes from time to time according the bank's operation and the "nested If" problem, I am looking for any solution to use "search" function like vlookup a listing. Thanks in advance your kind assistance. Fanny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Classify in categories | Excel Discussion (Misc queries) | |||
keyboard shortcuts - classify data | Excel Discussion (Misc queries) | |||
The SEARCH function and parsing data | Excel Worksheet Functions | |||
Function to search a row of data. | Excel Worksheet Functions | |||
HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA | Excel Worksheet Functions |