I need Excel help

I am building a monthly budget/cashflow from data dowloaded from my bank.
Spreadsheet DatNov22 Table DataNov22 Fields are Bank Account, Date, Description, Debit Amount, Credit Amount, Analysis, Group
Spreadsheet Inc&Exp Table DatAnalys Fields are Lookup, Analysis, Group

Spreadsheet DatNov22 Table DataNov22 Field Description is Text of variable length, which contains the transaction to be analysed
eg = INTEREST PAID
eg = WITHDRAWAL-OSKO PAYMENT 1037376 The Spring Waterman Inv 0767465

I need a formula which will: Search sheet DatNov22 Table DataNov22 Field Description
to find all matching instances of text in sheet Inc&Exp Table DatAnalys Field Lookup
and,
fill Spreadsheet DatNov22 Table DataNov22 Fields Analysis and Group

Can someone help me with this?