V-lookup copy down help

[pup33pawz]

Hello! I was wondering if someone could help me formulate a V-Lookup formula for this case:

After I type in the project # into Sheet 1 A2 & A3, I would like B2 & B3 to automatically be filled with Sheet 2's column D with either "First" or "Second". Right now I have =Vlookup(B2,Sheet2!A2:D2,4,False). I am unable to copy down the formula and to get Sheet 1 B3 to autofill with "Second".

Sheet 1:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Project #
[/TD]
[TD]Milestone
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]123
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]789
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Sheet 2:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Project #
[/TD]
[TD]Phase
[/TD]
[TD]Client
[/TD]
[TD]Milestone
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]123
[/TD]
[TD]ABC
[/TD]
[TD]Roger
[/TD]
[TD]First
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]123
[/TD]
[TD]ABC
[/TD]
[TD]Kathy
[/TD]
[TD]First
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]123
[/TD]
[TD]ABC
[/TD]
[TD]Ingrid
[/TD]
[TD]First
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]789
[/TD]
[TD]DEF
[/TD]
[TD]Michaelson
[/TD]
[TD]Second
[/TD]
[/TR]
</tbody>[/TABLE]


Thank you in advance!

 

[Aladin Akyurek]

You need something like:

=VLOOKUP(B2,Sheet2!$A$2:$D$2,4,0)

where 0 functions like FALSE.

 

[pup33pawz]

Thank you for your reply. When I insert this formula I get a circular warning? Could it be instead of =VLOOKUP(B2 it should be A2?

 

[Aladin Akyurek]

Thank you for your reply. When I insert this formula I get a circular warning? Could it be instead of =VLOOKUP(B2 it should be A2?

Obviously...

B2, copied down:

=VLOOKUP($A2,Sheet2!$A$2:$D$2,4,0)

 

[pup33pawz]

When I copy that formula down into Sheet1 Column B. It is returning with #N/A:

after copying formula down using =VLOOKUP($A2,Sheet2!$A$2:$D$2,4,0)
[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Project #
[/TD]
[TD]Milestone
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]123[/TD]
[TD]First
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]789
[/TD]
[TD]#N/A
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD]#N/A
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD]#N/A
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

When I copy that formula down into Sheet1 Column B. It is returning with #N/A:

after copying formula down using =VLOOKUP($A2,Sheet2!$A$2:$D$2,4,0)
[TABLE="class: cms_table_grid, width: 500"]
<TBODY>[TR]
[TD][/TD]
[TD]A

[/TD]
[TD]B

[/TD]
[/TR]
[TR]
[TD]1

[/TD]
[TD]Project #

[/TD]
[TD]Milestone

[/TD]
[/TR]
[TR]
[TD]2

[/TD]
[TD]123
[/TD]
[TD]First
[/TD]
[/TR]
[TR]
[TD]3

[/TD]
[TD]789
[/TD]
[TD]#N/A
[/TD]
[/TR]
[TR]
[TD]4

[/TD]
[TD][/TD]
[TD]#N/A
[/TD]
[/TR]
[TR]
[TD]5

[/TD]
[TD][/TD]
[TD]#N/A
[/TD]
[/TR]
</TBODY>[/TABLE]

It should be:

=VLOOKUP($A2,Sheet2!$A$2:$D$5,4,0)

Or as precaution...

=VLOOKUP($A2,Sheet2!A:D,4,0)

 

[pup33pawz]

Works perfect. Thank you for all your help

 

[Aladin Akyurek]

Works perfect. Thank you for all your help

You are welcome.