Check Contact Name in Column, Return Latest Date and 2 Cells Next to the Latest Date

I have a list in Column A of Names.
I need to check whether the contents of cell B6 appear in the values of Column A and return a TRUE or FALSE in cell B8.
I also want to be able to check if that name exists in Column A, to find the latest date the person was contacted on (i believe i have done this).
I then want to return the two values next to the latest date in cells B11 and B12.

Thank you for any help <3

put the following formula in cell B8:

Please Login or Register  to view this content.

If your data is going to expand to the right as it appears, you are going to run into problems with what you want to do. I suggest a vertical arrangement of your data like the enclosed. The summary is done with a Pivot Table.

Hi, welcome to the forum

B8=ISNUMBER(MATCH(B6,$A$2:$A$3,0))

for the others, these will work...
=INDEX(B2:J2,MATCH(MAX(B2:J2),B2:J2,0))
=INDEX(B2:J2,MATCH(MAX(B2:J2),B2:J2,0)+1)
=INDEX(B2:J2,MATCH(MAX(B2:J2),B2:J2,0)+2)

However, I need to put something together to ID which row to use

B8 =if(vlookup(b6,a2:a3,1,0)=b6,true,false)
b11 =if(vlookup(b6,a2:d3,1,0)=b6,vlookup(b6,a2:d3,3,0))
b12 =if(vlookup(b6,a2:d3,1,0)=b6,vlookup(b6,a2:d3,4,0))

Here is an addition to my previous post. This has a small table like you have in your example. This small table's formulae adjust automatically as you enter data to the table of data.

Try this, it should do what you want....
B10=INDEX(OFFSET(B1,MATCH($B$6,$A$2:$A$3,0),0,1,COUNTA($B$1:$J$1)),MATCH(MAX(OFFSET(B1,MATCH($B$6,$A$2:$A$3,0),0,1,COUNTA($B$1:$J$1))),OFFSET(B1,MATCH($B$6,$A$2:$A$3,0),0,1,COUNTA($B$1:$J$1)),0))
B11=INDEX(OFFSET(B1,MATCH($B$6,$A$2:$A$3,0),0,1,COUNTA($B$1:$J$1)),MATCH(MAX(OFFSET(B1,MATCH($B$6,$A$2:$A$3,0),0,1,COUNTA($B$1:$J$1))),OFFSET(B1,MATCH($B$6,$A$2:$A$3,0),0,1,COUNTA($B$1:$J$1)),0)+1)
B12=INDEX(OFFSET(B1,MATCH($B$6,$A$2:$A$3,0),0,1,COUNTA($B$1:$J$1)),MATCH(MAX(OFFSET(B1,MATCH($B$6,$A$2:$A$3,0),0,1,COUNTA($B$1:$J$1))),OFFSET(B1,MATCH($B$6,$A$2:$A$3,0),0,1,COUNTA($B$1:$J$1)),0)+2)