Sheets 1 and 2 both have columns that have unique customer I.D.#s.

Sheet 2 does not have ALL unique customer I.D. #s but Sheet 1 does.

Sheet 2 has another column with a numeric value that I want to pull to sheet
one for each unique customer I.D.

So....I need something to say if this ID# is found in this range of ID#s in
sheet two then put the value of in the cell next to the ID# in sheet 2 into
this cell in sheet 1.