Hi: This is my first post, and hope that I can explain my problem clearly.

I have a list of 64 bowlers with ID numbers, names, and bowling averages in cells A1:A64 (ID#s) , B1:B64 (Names), and C1:C64 (Averages) in an Excel list. I have another worksheet with blank cells starting with cells A75 (ID#); B75 (Name); and C75 (Avg) that needs to have the correct information for each bowler automatically fill cells B75 (name) and C75 (average) when the bowler's ID number is entered in cell A75. Please help me with a formula that will search for the ID# that matches the ID# entered into ID# cell of the blank worksheet, and when the matching ID number is found, the name and average of that particular bowler will automatically fill the corresponding cells.

I have tried Vlookup and If/Then, but can't make them work correctly. The next sentence helps explain what I need the formula to achieve:

If the ID# entered into cell A75 = "1", then bowler #1's name and average information is retrieved from the bowlers' list and fills in cells B75 and C75. If the ID# entered does not = "1", then search the list for the matching ID# of "2", or "3", ... "64" until a match is found. When the matching bowler's ID# is found, the name and average information for this bowler is retrieved and fills in their respective cells.

I really hope this is clear! Thank you in advance to all who work on this formula. Jan