Simply precede the appropriate references with the sheetname, such as 'my
sheet'!$A$1:$A$15

--
HTH

Bob Phillips

"nick" wrote in message
...
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!