If it’s a small file, it’s easy enough to just use a for each row, then use an if statement.
Read range → save as dt1
for each row in dt1
if row.item(“lastname”).tostring.ToUpper = “STARK” AndAlso row.item(“firstname”).tostring.toupper = “TONY”
then assign row.item(“GSA”) = “your text here”
assign row.item(“OFAC”) = “your text here”
Write range dt1
I type in the value I was looking for
Output Row Index
Assign Range Variable (Cell Letter + Index)
Write Cell
Set the range where the data is to be written