vlookup or if/then with data validation and multiple spreadsheets

[mboatright]

OK. I used validation to create a dropdown list of people's names on
spreadsheet. My problem is that I need to link the people's names t
bring data into a ceartian selection of cells. I Have been looking fo
vlookup tips, but I'm afraid that won't work. Please help me!(I gues
I need to make sure the old values clear out when I hit 'Clear' Too

 

[Frank Kabel]

Hi
not really sure what you issue is but see
http://www.mvps.org/dmcritchie/excel/vlookup.htm
for some information about VLOOKUP