URGET VLOOKUP HELP!
 

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!

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!

Hi bob,

i assign the rows A1:A15, it works, but lets say if i add one more job # in
the 16th row, its giving me N/A or a different # randomly. Any suggestions?

"Bob Phillips" wrote:

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!

You need a dynamic range, such as

OFFSET('my sheet'!$A$1,0,0,COUNTA('my sheet'!$A:$A))

instead of $A$1:$A$15

--
HTH

Bob Phillips

"nick" wrote in message
...
Hi bob,

i assign the rows A1:A15, it works, but lets say if i add one more job #
in
the 16th row, its giving me N/A or a different # randomly. Any
suggestions?

"Bob Phillips" wrote:

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!