Help With VLookup

I have 3 spreadsheets open next to one another- Sheet 1 has a list of every sales representative and their sales results for the current year, while Sheets 2 and 3 each have some of the sales representatives listed (they're split up into 2 different geographical zones) I need to format VLookup's to search for the sales reps name on Sheet one, and return their sales results to corresponding cells on Sheets 2 and 3. It seems like it should be pretty basic, but I am not sure if I am missing anything in my formula. Here is an example:

Sheet 1
Name: Sales:
John Doe 20
Jane Smith 35
Tom Brown 40
Mike Jones 27

Sheet 2
Name:
John Doe
Mike Jones

Sheet 3
Name:
Jane Smith
Tom Brown

Any help would be greatly appreciated.

What is the formula you are using?

=VLOOKUP(G5,Sheet1!$K:$T,Sheet1!,10, False)

10 is "Column 10" in the table array, but its returning an error every time I try to reference it.

Hi! This way?

I just spread the formula to the whole column, and it worked save for the first entry...never seen that happen before. Any ideas?

Yeah, you have a second "Sheet1!" in your formula above... just delete it (incl. the comma)...