hi there, how may i do this:

objective is autofill of a preset value on cell B upon entry of another value on cell A.

if i have on sheet 1 two columns, one has names and the other has numbers.

on sheet 2 i want to use an autofill BUT such that when i enter a name on, say A1 the corresponding number (from sheet 1, column two) will automatically be entered also?

as if saying, value/name entry on A1 will rig data from another sheet to enter value on B1

thanks