Auto-fill from one sheet to another without V-lookup

[pup33pawz]

Hello,

Is there a formula I can use to complete this action? I am unable to use V-lookup since the information is split up and not left to right.

I'd like to pull information from Sheet 1 D2
Sheet 1:

	A	B	C	D
1	Project #	Phase	Client	Milestone
2	1234	ABC	Roger	First

<tbody>
</tbody>

To insert into Sheet 2 B2
Sheet 2:

	A	B
1	Project #	Milestone
2	1234

<tbody>
</tbody>

I really appreciate any help on this one!

 

[VoG]

Your example is not very informative - maybe INDEX/MATCH http://www.contextures.com/xlFunctions03.html

 

[pup33pawz]

Hello, I would like to take the text "First" from Sheet 1 D2 to auto populate into Sheet 2 B2 so that when I plug in the Project # into Sheet 2 A2, B2 would auto populate with "First". Could you help me with the formula for that if it is possible?

 

[VoG]

I don't see why you cannot use VLOOKUP.

 

[pup33pawz]

My understanding of V-lookup is that the two columns I am referencing should be right next to each other. The V-lookup would look at Sheet 1 but the two columns are at different ends (column A and column D). Is this understanding correct?

 

[VoG]

Try

=VLOOKUP(A2,Sheet1!A1:D10,4,FALSE)

See http://www.contextures.com/xlFunctions02.html

 

[pup33pawz]

I have a dilemma. What would the solution be if the Sheet 1 looked like this:

	A	B	C	D
1	Project #	Phase	Client	Milestone
2	1234	ABC	Roger	First

<tbody>
</tbody>

3 1234 ABC Roger First
4 1234 ABC Roger First
5 1234 ABC Roger First
6 6548 DEF Kathy Second

and Sheet 2 only wants a single line for each different project #?

Sheet 2

	A	B
1	Project #	Milestone
2	1234

<tbody>
</tbody>

3 6548