Need help with auto population

consider me a new excel user. So, I dont really know what you mean by that

Can you attach yoru file?

attached

Thanks for attaching the file. But I do not see any unique names in Column A of any of the tabs in the workbook.
Can you please clarify what exactly what columns you are looking at as reference and what you want on the other tabs?

Ignore the Pokedex sheet. I want to be able to type a pokemon name (the unique name, as no pokemon have the same same, except a select few which Ive altered to be unique) in column A of the Team sheet, and have its stats auto input into the rest of the table. The source sheet being Perdex.

So let me know what questions you have!!
OK - you kept saying Column A, that's where I was confused, it is actually column B the Pokemon name.

What I am doing is called a VLOOKUP formula. It looks at one value and finds that value on another sheet plus other info from that other sheet.

So look on the Team tab, 1st entry under Type 1, line 2, you will see formula =VLOOKUP(B2,Perdex!$C$2:$S$699,9,FALSE). What it does is it looks at B2 on that tab, Team tab, and compares it to the Peredex tab and Columns C - S and then depending on the next number in the formula, in this case 9, it looks at that column, 9, starting and including Column C and puts that info there. The False in the formula means it is an exact match.

Type 2 is 10 columns over so that is why the formula has a 10 in Column D, Ability I is 11 columns thus 11 in Column E, and so on. I stopped at Physical/Special wasn't sure what you were looking for there.

When you copy the formula down, like in line 3, the B2 becomes B3, in line 4 it becomes B4, etc.

Now your color codes have messed up from what you had because of the color you had in line 2 when I copied the formula down. You can use Conditional Formatting to automatically highlight Grass Green, or Fire Red, etc.


Hope all this makes sense, if not please let me know!!