Excel help needed. I have all 100 pairs of pick 3 placed into cells $A$1 : $A$100. (1pair per cell)
I have a corresponding value (0:9) in cells B$1: B$100.
I have a 2nd corresponding value (0:9) in cells C$1: C$100.
I have a 3rd corresponding value (0:9) in cells D$1: D$100.
In cells M$301: M$1000 I have pick 3 pairs as they were drawn.
In cells O$301:O$1000 I would like to match the pairs in the “M” column with the matching value of the “B” column.
In cells P$301:P$1000 I would like to match the pairs in the “M” column with the matching value of the “C” column.
In cells Q$301:Q$1000 I would like to match the pairs in the “M” column with the matching value of the “D” column.
I have been using the Index/Match function and dragging to next cell to copy.
This works fine but I want to see if I can learn a little VBA..
Can someone show me what I need to use in a copy and paste to VBE?
Any and all help would be greatly appreciated.