The first thing you want to do is get the row index of “Mary” and you can do this with your IF statement inside of your for each row for when you’ve identified “Mary”.
Assign: MaryIndex = MyDT.Rows.IndexOf(row)
then its as simple as getting the value using MaryIndex:
EDIT: to give a better explanation:
MyDT.Rows(0).Item(0) = the A1 cell in Excel.
MyDT.Rows(2).Item(2) = the C4 cell in excel
Always start your row/column count at 0.
I realised, depending on how you are looping through your rows (e.g. if you’re using a counter) you could simply: