Linking Cells with Certain Information

[KTINVA]

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".

 

[BQardi]

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:

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]

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>