Populate a cell when another cell is referenced?

[jdpro]

	A​	B​	C​	D​	E​
1	Name​	Size​	​	Name​	Size (Kilograms)​
2	(if I input =D4)	(can this auto-fill from E4?)		Platypus	2.4
3				Porcupine	11
4				Pachyderm	5,000
5				Porpoise	76

Hello,

The above represents two separate sections of a worksheet. Columns D and E are populated with data that will be referenced in a different section. Can I reference D4 in A2, and have it automatically fill B2 with E4? Then the result in A2 would be "Pachyderm" and the result in B2 would be "5,000."

Thanks as always for your assistance.

 

[Cubist]

In B2:

=VLOOKUP(A2,$D$2:$E$5,2,FALSE)

 

[jdpro]

Thank you very much, Cubist.