i want the name to be put in the column next to the number i searched for in
sheet 1, i want it to remain in sheet 1, even when i remove it from sheet 2
--
thanks


"bj" wrote:

Look at Vlookup in help.
do you want the name put in column B in the first or second sheet?

"Mike" wrote:

Hi i have a sheet with 600 numbers in column A, what i want to do is to be
able to search for a number in column A from a different sheet and place a
name by that number in column B. Hope you can help
--
thanks