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

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.