I have an excel spreadsheet that is in essence a cross reference. Row A has 20 or so unique values. I need to find the column in which a particular value is a match, so I can grab the values from the same in column but in other rows. So if I am looking of “monkey” and I find it in row 1 and column F, then I want to be able to grab balls from row 2 and three in column F.
This should be easy I believe, but I am really struggling with this? I want to use a For Each column activity, or a datable lookup on the first row.
Any assistance would be greatly appreciated.