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:
[TABLE="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]1234
[/TD]
[TD]ABC
[/TD]
[TD]Roger
[/TD]
[TD]First
[/TD]
[/TR]
</tbody>[/TABLE]


To insert into Sheet 2 B2
Sheet 2:
[TABLE="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]1234
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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:
[TABLE="class: cms_table, 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]1234
[/TD]
[TD]ABC
[/TD]
[TD]Roger[/TD]
[TD]First
[/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="class: cms_table, 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]1234
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
3 6548