Finding a match
I'm trying to find a match in field "sbc20" that matches a variable in field "Winner 1". When it does match, put the number 20 in field "M20". All fields are on the same table. I had it working but I didn't use a variable. I'm thinking this may be the way to go.
When it is done with "sbc20" it will need to go to "sbc19" and put 19 in "M19" and so on to "M10". It's probably an easy one but it has me stumped.