Welcome Guest
Log In | Register )
You last visited December 10, 2016, 11:28 am
All times shown are
Eastern Time (GMT-5:00)

Excel help needed

Topic closed. Posted 5 years ago. No replies.

Page 1 of 1
PrintE-mailLink
ram's avatar - Lottery-002.jpg

United States
Member #11
December 6, 2001
75 Posts
Offline
Posted: July 19, 2011, 8:45 am - IP Logged

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.