#### encioman

##### Board Regular
Dear Experts,
Kindly share me a formula which links the two sheets making the data fill as shown:

 Sheet #1 A 1 SUGAR B 2 COFFEE C 3 SALT D 4 OIL Sheet #2 1 2 3 4 C SALT B COFFEE A SUGAR D OIL

<colgroup><col width="64" span="5" style="width: 48pt; text-align: center;"> </colgroup><tbody>
</tbody>

Regards,
encioman

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### timfritsch

##### Active Member
Assuming the tables in both sheets start in cell A1, the formula in cell B2 of the second sheet is:

=IF(VLOOKUP(\$A2,Sheet1!\$A\$1:\$C\$4,2,FALSE)=B\$1,VLOOKUP(\$A2,Sheet1!\$A\$1:\$C\$4,3,FALSE),"")

You can copy the formula to the remaining cells in the second sheet table.

Tim

#### encioman

##### Board Regular
Thank you so much...it worked in the first cell but when i copied...the result is blank

#### encioman

##### Board Regular
Dear Tim or anyone,

How would I do that "VINEGAR" must be in column 5 (F12) not that "OIL" in column 4

 A B C D E F 1 A 1 SUGAR 2 B 2 COFFEE 3 C 3 SALT 4 D 4 OIL 5 D 5 VINEGAR 6 7 SHT. #2 8 1 2 3 4 5 9 C SALT 10 B COFFEE 11 D OIL 12 D OIL 13 A SUGAR 14 C SALT

<tbody>
</tbody>

Last edited:

Replies
0
Views
146
Replies
7
Views
343
Replies
3
Views
255
Replies
9
Views
320
Replies
28
Views
381

1,195,858
Messages
6,011,980
Members
441,661
Latest member
Pammie007

### 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