Thank you Peo. This worked for the first row (A2), but when I copy the
formula down, each row returns the same info, rather than returning the
info from the row where it is finding my value.

Is this something to do with the absolute reference in this part of the
formula: COLUMNS($A$1:A1) ?? The "A1" will change to "B1", etc., of
course, as I copy it down, but the data returned is still the info from
line A.