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:

	A	B
1	Project #	Milestone
2	123
3	789

<tbody>
</tbody>

Sheet 2:

	A	B	C	D
1	Project #	Phase	Client	Milestone
2	123	ABC	Roger	First
3	123	ABC	Kathy	First
4	123	ABC	Ingrid	First
5	789	DEF	Michaelson	Second

<tbody>
</tbody>

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)

	A	B
1	Project #	Milestone
2	123	First
3	789	#N/A
4		#N/A
5		#N/A

<tbody>
</tbody>

 

[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)

	A	B
1	Project #	Milestone
2	123	First
3	789	#N/A
4		#N/A
5		#N/A

<TBODY>
</TBODY>

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.