Lookup value from sheet1 in sheet2 to pull corresponding data and bring them to sheet 1

Sorry, I attached an image to my OP after realizing nothing lined up in the post.

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Here's a sample...

Basically, I would like sheet 1 to be updated with the info in sheet 2. The result would be as shown in sheet 3 and any info added to sheet 2 would update automatically in sheet 1.

Thanks again!

In F2

=IF($A2="","",IFERROR(VLOOKUP($A2,Sheet2!$A$2:$D$1000,3,0),""))

in G2

=IF($A2="","",IFERROR(VLOOKUP($A2,Sheet2!$A$2:$D$1000,4,0),""))

copy both as far as required

Thank you very much.

If you care to enlighten me, can you confirm my understanding...

I also need the return from column B of sheet2 in column E, so in E2, I put:


=IF($A2="","",IFERROR(VLOOKUP($A2,Sheet2!$A$2:$D$1000,2,0),""))

Is the number 2 what defines the column to pull data from? (2=B, 3=C, 4=D, etc...)

And am I understanding that the first $A2 refers to the source list in sheet1 and the second $A2 refers to the result list in sheet2, therefore if my order numbers would be in the column B of sheet 1 instead, I would have =IF($B2="","",IFERROR(VLOOKUP($A2,Sheet2!$A$2:$D$1000,2,0),""))
and if the order numbers are in column C of sheet 2, the formula would have to be: =IF($B2="","",IFERROR(VLOOKUP($C2,Sheet2!$A$2:$D$1000,2,0),""))

I'm not too sure what these values refer to: $A$2:$D$1000

Thanks again

Originally Posted by Xsample

Thank you very much.

If you care to enlighten me, can you confirm my understanding...

I also need the return from column B of sheet2 in column E, so in E2, I put:


=IF($A2="","",IFERROR(VLOOKUP($A2,Sheet2!$A$2:$D$1000,2,0),""))

Is the number 2 what defines the column to pull data from? (2=B, 3=C, 4=D, etc...)

And am I understanding that the first $A2 refers to the source list in sheet1 and the second $A2 refers to the result list in sheet2, therefore if my order numbers would be in the column B of sheet 1 instead, I would have =IF($B2="","",IFERROR(VLOOKUP($A2,Sheet2!$A$2:$D$1000,2,0),""))
and if the order numbers are in column C of sheet 2, the formula would have to be: =IF($B2="","",IFERROR(VLOOKUP($C2,Sheet2!$A$2:$D$1000,2,0),""))

I'm not too sure what these values refer to: $A$2:$D$1000

Thanks again

Both $A2 refer to your sheet 1. Sheet2!$A$2:$D$1000 refer to the range that you want to lookup the data for that is equal to Sheet 1 $A2. As for the 2 = B 3 = C 4 = D, depends on the range you set. Since it is starting at Sheet 2 range A:D, A will be 1 and thereafter. if you set it to Sheet 2 range B:D, B will be 1.