Sheet 1 has column A, with a list of names...column B has the list of ID numbers that correspond to each name. Sheet 2 Column A has a data validation list, which was created from the names on Sheet 1, column A. Sheet 2 column B is blank. I would like to choose a name from Column A in Sheet 2 and have the corresponding ID number from Column B in Sheet 1, populate to Column B in Sheet 2. I hope I'm clear. Thank you in advance.