Chris,

A little confused, but I can try to help.

Your first sheet will contain the "Segment ID" and the "User ID"? Say:
User Segment
123 1
124 2
125 3
126 4

Your second sheet will contain the "User ID" multiple times, and you want it
to pull the "Segment ID"? Say:
User Segment (Formula)
123 1
123 1
124 2
125 3
125 3
126 4
126 4
126 4


"Chris N" wrote:

Is there a formula which will compare cells between 2 worksheets and then is
they match add from another cell? For example, I have 2 worksheets and each
worksheet has the same user ID. However 2nd worksheet has the user ID more
than once (which is fine). What I want to do is if they are equal then add
the segment ID from another cell from worksheet 1.