# Linking Cells with Certain Information

#### KTINVA

##### New Member
Is it possible to enter a number in one cell and have the cells in the adjacent row automatically fill in with additional information (text and numbers)?

Example:
 1 A B C D 2 100 Cat 8 lbs. 5 3 101 Dog 15 lbs. 12 4 102 Fish 4 oz. 2 5 103 Rabbit 7 lbs. 27 6 104 Snake 1 lb. 6

<tbody>
</tbody>

If I enter "102" in a cell on another sheet in the same document I would like for the next cell to read "Fish", the next cell in the row to say "4 oz.", and the next to be "2".

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### BQardi

##### Active Member
You could just use VLOOKUP:
In "Sheet2" or whatever your lookup sheet is called, f.ex. enter 102 in A1 and information will show in B1, C1 and D1:
Assuming your lookup data is in Sheet1:
Code:
``````Cell B1 formula: =VLOOKUP(A1,Sheet1!A:B,2,FALSE)
Cell C1 formula: =VLOOKUP(A1,Sheet1!A:C,3,FALSE)
Cell D1 formula: =VLOOKUP(A1,Sheet1!A:D,4,FALSE)``````

#### live_excel

##### New Member
Hello,

Here's i did this formula for you.Please try this and let me know.

 1 A B C D G1 ---> 102 2 100 Cat 8 lbs. 5 3 101 Dog 15 lbs. 12 =VLOOKUP(G1,B1:E6,2,FALSE) 4 102 Fish 4 oz. 2 5 103 Rabbit 7 lbs. 27 6 104 Snake 1 lb. 6

<colgroup><col span="5"><col><col></colgroup><tbody>
</tbody>

Replies
14
Views
1K
Replies
8
Views
209
Replies
4
Views
227
Replies
3
Views
321
Replies
13
Views
691

1,195,601
Messages
6,010,654
Members
441,558
Latest member
lambierules

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