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

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