JOB # DOC # for that JOB POPULATED
10300-05-2046 100013224 100013224
10300-05-2046 100013225 100013225
10300-05-2101 100131202 100131202
10300-05-2112 100013226 100013226
10324-05-2109 100013228 100013228
10338-05-2076 100013230 100013230

Formula Used:
=INDEX($B$1:$B$15,SMALL(IF($A$1:$A$15=$a$1,ROW($A$ 1:$A$15)),ROW(A2)))

This formula works in the same worksheet. In my case, i have to take the job
# from one worksheet, Doc # from one worksheet and populate the document # in
a different worksheet using Vlookup. How do i do that? Any help is
appreciated!