LOOKUP FOR A SPECIFIC SINGLE OR SET OF SEARCH ARGUEMENTS AND IF FOUND RETURN A VALUE AND LOAD IT

%3CLINGO-SUB%20id%3D%22lingo-sub-2277961%22%20slang%3D%22en-US%22%3ELOOKUP%20FOR%20A%20SPECIFIC%20SINGLE%20OR%20SET%20OF%20SEARCH%20ARGUEMENTS%20AND%20IF%20FOUND%20RETURN%20A%20VALUE%20AND%20LOAD%20IT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277961%22%20slang%3D%22en-US%22%3E%3CP%3EI%20AM%20INTERESTED%20IN%20A%20LARGE%20SPREAD%20SHEET%20TO%20LOOK%20FOR%20ONE%20OR%20MORE%20SEARCH%20ARGUEMENTS%20AND%20MATCH%20IT%20IN%20A%20TABLE%20TO%20FIND%20THE%20CORRESPONDING%20RESULTANT%20CODE%2C%20OR%20VALUE%20TO%20RETURN%20TO%20A%20CELL%20OR%20ARRAY.%3C%2FP%3E%3CP%3EEXAMPLE%3A%3C%2FP%3E%3CP%3ESUPPOSE%20I%20HAVE%20A%20DOWNLOADED%20BANK%20TRANSACTIONS%20FILE%20AS%20A%20SPREADSHEET%20WITH%20VARIOUS%20COLUMNS%20I%20WOULD%20LIKE%20TO%20SEARCH%20THE%20MEMO%20OR%20DESCRIPTION%20FIELD%20FOR%20A%20SPECIFIC%20SERVICE%20OR%20SET%20OF%20SERVICES%20%2F%20PROVIDERS%26nbsp%3B%20OR%20NAME%20OF%20PROVIDER%20AND%20CORRESPONDINGLY%20PICK%20UP%20%5B%20FROM%20A%20LOOKUP%20TABLE%5D%20THE%20SUITABLE%20%5BSAY%5D%20ACCOUNT%20CODE%20CORRESPONDING%20TO%20MY%20ACCOUNTING%20SYSTEM%20AND%20PUT%20OR%20TAG%20IT%20IN%20THE%20SAME%20ROW%20IN%20A%20NEW%20COLUMN.%20LATER%20I%20WOULD%20USE%20A%20PIVOT%20TABLE%20TO%20SUMMARISE%20THESE%20ACCOUNTS%20AND%20CREATE%20A%20CORRESPONDING%20JOURNAL%20ENTRY%20FOR%20MY%20ACCOUNTING%20SOFTWARE%26nbsp%3B%3CSPAN%3ESUCH%20AS%20MYOB.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EDO%20WE%20HAVE%20SUCH%20A%20FACILITY%20IN%20EXCEL.%3F%20OTHERWISE%20DECVELOP%20IT.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EMANI%20alias%20HIPPO%20%5B%2050%20YEARS%20OF%20SOFTWARE%20DEVELOPING%20BACKGROUND%5D%2020%2F4%2F21%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2283119%22%20slang%3D%22en-US%22%3ERe%3A%20LOOKUP%20FOR%20A%20SPECIFIC%20SINGLE%20OR%20SET%20OF%20SEARCH%20ARGUEMENTS%20AND%20IF%20FOUND%20RETURN%20A%20VALUE%20AND%20LOAD%20IT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2283119%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1030432%22%20target%3D%22_blank%22%3E%40MANISALEM45%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20change%20your%20message%20from%20unreadable%20All%20Caps%20to%20normal%20font%20and%20ask%20your%20question%20Excel%20community%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EExcel%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EThis%20place%20is%20specifically%20to%20discuss%20techcommunity%20resource%20itself.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2424007%22%20slang%3D%22en-US%22%3ERe%3A%20LOOKUP%20FOR%20A%20SPECIFIC%20SINGLE%20OR%20SET%20OF%20SEARCH%20ARGUEMENTS%20AND%20IF%20FOUND%20RETURN%20A%20VALUE%20AND%20LOAD%20IT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2424007%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1030432%22%20target%3D%22_blank%22%3E%40MANISALEM45%3C%2FA%3E%26nbsp%3BThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B-%20I%20have%20moved%20this%20discussion%20to%20the%20Excel%20discussion%20space.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I AM INTERESTED IN A LARGE SPREAD SHEET TO LOOK FOR ONE OR MORE SEARCH ARGUEMENTS AND MATCH IT IN A TABLE TO FIND THE CORRESPONDING RESULTANT CODE, OR VALUE TO RETURN TO A CELL OR ARRAY.

EXAMPLE:

SUPPOSE I HAVE A DOWNLOADED BANK TRANSACTIONS FILE AS A SPREADSHEET WITH VARIOUS COLUMNS I WOULD LIKE TO SEARCH THE MEMO OR DESCRIPTION FIELD FOR A SPECIFIC SERVICE OR SET OF SERVICES / PROVIDERS  OR NAME OF PROVIDER AND CORRESPONDINGLY PICK UP [ FROM A LOOKUP TABLE] THE SUITABLE [SAY] ACCOUNT CODE CORRESPONDING TO MY ACCOUNTING SYSTEM AND PUT OR TAG IT IN THE SAME ROW IN A NEW COLUMN. LATER I WOULD USE A PIVOT TABLE TO SUMMARISE THESE ACCOUNTS AND CREATE A CORRESPONDING JOURNAL ENTRY FOR MY ACCOUNTING SOFTWARE SUCH AS MYOB.

 

DO WE HAVE SUCH A FACILITY IN EXCEL.? OTHERWISE DECVELOP IT.

 

MANI alias HIPPO [ 50 YEARS OF SOFTWARE DEVELOPING BACKGROUND] 20/4/21

2 Replies

@MANISALEM45 

Please change your message from unreadable All Caps to normal font and ask your question Excel community here Excel (microsoft.com)

This place is specifically to discuss techcommunity resource itself.

@MANISALEM45 Thanks @Sergei Baklan - I have moved this discussion to the Excel discussion space.