How to automatically match cell info from one sheet to another if it matches a cell in she

Hi everyone,

I've just been given this forum to use if i need help with excel. I'm very basic at excel but am trying to improve. Any help i receive is greatly appreciated.

I don't know excel well. I have tried searching online on how to match cells from one cell on one sheet to that in another cell.

I've seen in another spread sheet this formula =SUMPRODUCT(--('INVOICES FULL BKDOWN'!$A$4:$A$144=$B$19),--('INVOICES FULL BKDOWN'!$B$4:$B$144=$B$24),--('INVOICES FULL BKDOWN'!$C$4:$C$144=$C$24),'INVOICES FULL BKDOWN'!$F$4:$F$144)

I have tried some of the suggestions on google for product If & index , match, i just can't get it to work.

In the spreadsheet attached i have added this in for what i'd like to achieve.


Test 1 from AG4:AG203 ( AG4) on all clients incl contacts tab if sheet1A3 matches name in D4:D203
12345dcvt3 from Ah4:Ah203 ( Ah4) on all clients incl contacts tab if sheet1A3 matches name in D4:D203
08/04/2024 from Ai4:Ai203 ( Ai4) on all clients incl contacts tab if sheet1A3 matches name in D4:D203
zero from Aj4:Aj203 ( Aj4) on all clients incl contacts tab if sheet1A3 matches name in D4:D203
01/01/2027 from Ak4:Ak203 ( Ak4) on all clients incl contacts tab if sheet1A3 matches name in D4:D203
Flowers from AL4:AL203 ( AL4) on all clients incl contacts tab if sheet1A3 matches name in D4:D203
daffodil from AM4:AM203 ( AM4) on all clients incl contacts tab if sheet1A3 matches name in D4:D203
03/03/2024 from AN4:AN203 ( AN4) on all clients incl contacts tab if sheet1A3 matches name in D4:D203
Zero from AO4:AO203 ( AO4) on all clients incl contacts tab if sheet1A3 matches name in D4:D203
16/07/2029 from AP4:AP203 ( AP4) on all clients incl contacts tab if sheet1A3 matches name in D4:D203

I'd be very grateful if anyone can help point me in the right direction on what to use.

Many thanks in advance