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

#### pup33pawz

##### New Member
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!

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
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?

I don't see why you cannot use VLOOKUP.

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?

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

Replies
10
Views
457
Replies
1
Views
168
Replies
9
Views
367
Replies
1
Views
375
Replies
2
Views
406

1,219,998
Messages
6,151,379
Members
451,024
Latest member
saotome1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back