I've copied snippets of my data from two tabs: "Pokémon" & "Fast TMs".
As an example, we'll use Nidoking, who's pokédex number is 34.
I need cell I16 in the first table to find Nidoking's # ("34") in the second table (cell M6) and return the name of his Move ("Iron Tail"). I'll then need a formula for cell J16 that can ignore the first move we found (which will go in the "FM1" column) and find his 2nd Move (for the "FM2" column). The "CM" columns are for their Charged Moves, and each pokémon (with one exception) has 1 to 6 Charged Moves available to them. (Now that I look closer at it, Mew [#151] would probably be a better example since it has three separate moves in the example data set...)
I've tried for a while now to Google the answer to this, but everything I'm finding requires known row and/or column numbers or sorted data unless you write the formula to repeat itself for each individual column or row. (except maybe some form of Index-Match, but I tried =MATCH(I5,I5:BO67,0) in cell A1 of the 2nd table and got #N/A, so .... not sure what that's about)
I'm sure there's likely a good way to accomplish this using VBA, but I have not yet learned VBA, so it'll be a little impractical in the future when new characters are released into the game and I need to update things. That said, if the only practical way to do this is VBA-based, then now may be the time for me to start learning.
Thank you in advance for your help. I thought I was B0$$ at Excel until I found myself trying to help people here one day, and I quickly learned that you geniuses are just a couple steps ahead of me. So I'm confident someone here will be able to help me figure this out.
PS -
Bonus Points if the formula returns "Ste - Iron Tail" instead.
Major Bonus Points for the formula that returns Mew's 2nd move in the data set ("Dra - Dragon Tail").
More Bonus Points if you figure out the "alola" thing for me, but I'm pretty confident I can get that part working if I can just get the lookup portion figured out.
[TABLE="width: 647"]
<tbody>[TR]
[TD]A1[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Gen[/TD]
[TD]#[/TD]
[TD]Name[/TD]
[TD]CP[/TD]
[TD]Type[/TD]
[TD]Type2[/TD]
[TD]#FM[/TD]
[TD]FM1[/TD]
[TD]FM2[/TD]
[TD]#CM[/TD]
[TD]CM1[/TD]
[TD]CM2[/TD]
[TD]CM3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2nd[/TD]
[TD]172[/TD]
[TD]Pichu[/TD]
[TD]376[/TD]
[TD]Electric[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1st[/TD]
[TD]25[/TD]
[TD]Pikachu[/TD]
[TD]787[/TD]
[TD]Electric[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1st[/TD]
[TD]26[/TD]
[TD]Raichu[/TD]
[TD]2025[/TD]
[TD]Electric[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Alolan[/TD]
[TD]26.1[/TD]
[TD]Alolan
Raichu[/TD]
[TD]2143[/TD]
[TD]Electric[/TD]
[TD]Psychic[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]1st[/TD]
[TD]27[/TD]
[TD]Sandshrew[/TD]
[TD]1194[/TD]
[TD]Ground[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]1st[/TD]
[TD]28[/TD]
[TD]Sandslash[/TD]
[TD]2328[/TD]
[TD]Ground[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Alolan[/TD]
[TD]27.1[/TD]
[TD]Alolan
Sandshrew[/TD]
[TD]1219[/TD]
[TD]Ice[/TD]
[TD]Steel[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Alolan[/TD]
[TD]28.1[/TD]
[TD]Alolan
Sandslash[/TD]
[TD]2366[/TD]
[TD]Ice[/TD]
[TD]Steel[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]1st[/TD]
[TD]29[/TD]
[TD]Nidoran♀[/TD]
[TD]736[/TD]
[TD]Poison[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]1st[/TD]
[TD]30[/TD]
[TD]Nidorina[/TD]
[TD]1218[/TD]
[TD]Poison[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]1st[/TD]
[TD]31[/TD]
[TD]Nidoqueen[/TD]
[TD]2338[/TD]
[TD]Poison[/TD]
[TD]Ground[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]1st[/TD]
[TD]32[/TD]
[TD]Nidoran♂[/TD]
[TD]739[/TD]
[TD]Poison[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]1st[/TD]
[TD]33[/TD]
[TD]Nidorino[/TD]
[TD]1252[/TD]
[TD]Poison[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]1st[/TD]
[TD]34[/TD]
[TD]Nidoking[/TD]
[TD]2386[/TD]
[TD]Poison[/TD]
[TD]Ground[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]2nd[/TD]
[TD]173[/TD]
[TD]Cleffa[/TD]
[TD]620[/TD]
[TD]Fairy[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
--------------------------------------------------
[TABLE="width: 930"]
<tbody>[TR]
[TD="align: center"]A1[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"]J[/TD]
[TD="align: center"]K[/TD]
[TD="align: center"]L[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]P[/TD]
[TD="align: center"]Q[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]S[/TD]
[TD="align: center"]T[/TD]
[TD="align: center"]U[/TD]
[TD]V[/TD]
[TD]W[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]from:[/TD]
[TD="colspan: 5"]https://pokeassistant.com/main/movelist[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]Type[/TD]
[TD]Fast Moves[/TD]
[TD]DPS[/TD]
[TD]Power[/TD]
[TD]Energy[/TD]
[TD]Cast Time[/TD]
[TD][/TD]
[TD="colspan: 3"]Pokémon[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]Ste[/TD]
[TD]Steel Wing[/TD]
[TD]13.8[/TD]
[TD]11[/TD]
[TD]6[/TD]
[TD]0.8s[/TD]
[TD][/TD]
[TD="align: right"]277[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]151[/TD]
[TD="align: right"]142[/TD]
[TD="align: right"]149[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]250[/TD]
[TD="align: right"]227[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]Ste[/TD]
[TD]Iron Tail[/TD]
[TD]13.6[/TD]
[TD]15[/TD]
[TD]7[/TD]
[TD]1.1s[/TD]
[TD][/TD]
[TD="align: right"]305[/TD]
[TD="align: right"]306[/TD]
[TD="align: right"]336[/TD]
[TD="align: right"]208[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]147[/TD]
[TD="align: right"]148[/TD]
[TD="align: right"]248[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]Dra[/TD]
[TD]Dragon Tail[/TD]
[TD]13.6[/TD]
[TD]15[/TD]
[TD]9[/TD]
[TD]1.1s[/TD]
[TD][/TD]
[TD="align: right"]306[/TD]
[TD="align: right"]330[/TD]
[TD="align: right"]149[/TD]
[TD="align: right"]350[/TD]
[TD="align: right"]373[/TD]
[TD="align: right"]383[/TD]
[TD="align: right"]384[/TD]
[TD="align: right"]151[/TD]
[TD="colspan: 2"]103 alola[/TD]
[TD="align: right"]208[/TD]
[TD="align: right"]249[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]Fig[/TD]
[TD]Counter[/TD]
[TD]13.3[/TD]
[TD]12[/TD]
[TD]8[/TD]
[TD]0.9s[/TD]
[TD][/TD]
[TD="align: right"]257[/TD]
[TD="align: right"]286[/TD]
[TD="align: right"]288[/TD]
[TD="align: right"]297[/TD]
[TD="align: right"]308[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]360[/TD]
[TD="align: right"]214[/TD]
[TD="align: right"]386[/TD]
[TD="align: right"]185[/TD]
[TD="align: right"]202[/TD]
[TD="align: right"]217[/TD]
[TD="align: right"]232[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]Roc[/TD]
[TD]Rock Throw[/TD]
[TD]13.3[/TD]
[TD]12[/TD]
[TD]7[/TD]
[TD]0.9s[/TD]
[TD][/TD]
[TD="align: right"]299[/TD]
[TD="align: right"]337[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]338[/TD]
[TD="align: right"]185[/TD]
[TD="align: right"]213[/TD]
[TD="align: right"]377[/TD]
[TD="align: right"]74[/TD]
[TD="colspan: 2"]74 alola[/TD]
[TD="colspan: 2"]75 alola[/TD]
[TD="colspan: 2"]76 alola[/TD]
[TD="align: right"]218[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD]Wat[/TD]
[TD]Waterfall[/TD]
[TD]13.3[/TD]
[TD]16[/TD]
[TD]8[/TD]
[TD]1.2s[/TD]
[TD][/TD]
[TD="align: right"]119[/TD]
[TD="align: right"]130[/TD]
[TD="align: right"]160[/TD]
[TD="align: right"]230[/TD]
[TD="align: right"]319[/TD]
[TD="align: right"]342[/TD]
[TD="align: right"]365[/TD]
[TD="align: right"]382[/TD]
[TD="align: right"]350[/TD]
[TD="align: right"]151[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD]Roc[/TD]
[TD]Smack Down[/TD]
[TD]13.3[/TD]
[TD]12[/TD]
[TD]7[/TD]
[TD]0.9s[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
As an example, we'll use Nidoking, who's pokédex number is 34.
I need cell I16 in the first table to find Nidoking's # ("34") in the second table (cell M6) and return the name of his Move ("Iron Tail"). I'll then need a formula for cell J16 that can ignore the first move we found (which will go in the "FM1" column) and find his 2nd Move (for the "FM2" column). The "CM" columns are for their Charged Moves, and each pokémon (with one exception) has 1 to 6 Charged Moves available to them. (Now that I look closer at it, Mew [#151] would probably be a better example since it has three separate moves in the example data set...)
I've tried for a while now to Google the answer to this, but everything I'm finding requires known row and/or column numbers or sorted data unless you write the formula to repeat itself for each individual column or row. (except maybe some form of Index-Match, but I tried =MATCH(I5,I5:BO67,0) in cell A1 of the 2nd table and got #N/A, so .... not sure what that's about)
I'm sure there's likely a good way to accomplish this using VBA, but I have not yet learned VBA, so it'll be a little impractical in the future when new characters are released into the game and I need to update things. That said, if the only practical way to do this is VBA-based, then now may be the time for me to start learning.
Thank you in advance for your help. I thought I was B0$$ at Excel until I found myself trying to help people here one day, and I quickly learned that you geniuses are just a couple steps ahead of me. So I'm confident someone here will be able to help me figure this out.
PS -
Bonus Points if the formula returns "Ste - Iron Tail" instead.
Major Bonus Points for the formula that returns Mew's 2nd move in the data set ("Dra - Dragon Tail").
More Bonus Points if you figure out the "alola" thing for me, but I'm pretty confident I can get that part working if I can just get the lookup portion figured out.
[TABLE="width: 647"]
<tbody>[TR]
[TD]A1[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Gen[/TD]
[TD]#[/TD]
[TD]Name[/TD]
[TD]CP[/TD]
[TD]Type[/TD]
[TD]Type2[/TD]
[TD]#FM[/TD]
[TD]FM1[/TD]
[TD]FM2[/TD]
[TD]#CM[/TD]
[TD]CM1[/TD]
[TD]CM2[/TD]
[TD]CM3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2nd[/TD]
[TD]172[/TD]
[TD]Pichu[/TD]
[TD]376[/TD]
[TD]Electric[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1st[/TD]
[TD]25[/TD]
[TD]Pikachu[/TD]
[TD]787[/TD]
[TD]Electric[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1st[/TD]
[TD]26[/TD]
[TD]Raichu[/TD]
[TD]2025[/TD]
[TD]Electric[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Alolan[/TD]
[TD]26.1[/TD]
[TD]Alolan
Raichu[/TD]
[TD]2143[/TD]
[TD]Electric[/TD]
[TD]Psychic[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]1st[/TD]
[TD]27[/TD]
[TD]Sandshrew[/TD]
[TD]1194[/TD]
[TD]Ground[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]1st[/TD]
[TD]28[/TD]
[TD]Sandslash[/TD]
[TD]2328[/TD]
[TD]Ground[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Alolan[/TD]
[TD]27.1[/TD]
[TD]Alolan
Sandshrew[/TD]
[TD]1219[/TD]
[TD]Ice[/TD]
[TD]Steel[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Alolan[/TD]
[TD]28.1[/TD]
[TD]Alolan
Sandslash[/TD]
[TD]2366[/TD]
[TD]Ice[/TD]
[TD]Steel[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]1st[/TD]
[TD]29[/TD]
[TD]Nidoran♀[/TD]
[TD]736[/TD]
[TD]Poison[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]1st[/TD]
[TD]30[/TD]
[TD]Nidorina[/TD]
[TD]1218[/TD]
[TD]Poison[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]1st[/TD]
[TD]31[/TD]
[TD]Nidoqueen[/TD]
[TD]2338[/TD]
[TD]Poison[/TD]
[TD]Ground[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]1st[/TD]
[TD]32[/TD]
[TD]Nidoran♂[/TD]
[TD]739[/TD]
[TD]Poison[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]1st[/TD]
[TD]33[/TD]
[TD]Nidorino[/TD]
[TD]1252[/TD]
[TD]Poison[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]1st[/TD]
[TD]34[/TD]
[TD]Nidoking[/TD]
[TD]2386[/TD]
[TD]Poison[/TD]
[TD]Ground[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]2nd[/TD]
[TD]173[/TD]
[TD]Cleffa[/TD]
[TD]620[/TD]
[TD]Fairy[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
--------------------------------------------------
[TABLE="width: 930"]
<tbody>[TR]
[TD="align: center"]A1[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"]J[/TD]
[TD="align: center"]K[/TD]
[TD="align: center"]L[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]P[/TD]
[TD="align: center"]Q[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]S[/TD]
[TD="align: center"]T[/TD]
[TD="align: center"]U[/TD]
[TD]V[/TD]
[TD]W[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]from:[/TD]
[TD="colspan: 5"]https://pokeassistant.com/main/movelist[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]Type[/TD]
[TD]Fast Moves[/TD]
[TD]DPS[/TD]
[TD]Power[/TD]
[TD]Energy[/TD]
[TD]Cast Time[/TD]
[TD][/TD]
[TD="colspan: 3"]Pokémon[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]Ste[/TD]
[TD]Steel Wing[/TD]
[TD]13.8[/TD]
[TD]11[/TD]
[TD]6[/TD]
[TD]0.8s[/TD]
[TD][/TD]
[TD="align: right"]277[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]151[/TD]
[TD="align: right"]142[/TD]
[TD="align: right"]149[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]250[/TD]
[TD="align: right"]227[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]Ste[/TD]
[TD]Iron Tail[/TD]
[TD]13.6[/TD]
[TD]15[/TD]
[TD]7[/TD]
[TD]1.1s[/TD]
[TD][/TD]
[TD="align: right"]305[/TD]
[TD="align: right"]306[/TD]
[TD="align: right"]336[/TD]
[TD="align: right"]208[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]147[/TD]
[TD="align: right"]148[/TD]
[TD="align: right"]248[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]Dra[/TD]
[TD]Dragon Tail[/TD]
[TD]13.6[/TD]
[TD]15[/TD]
[TD]9[/TD]
[TD]1.1s[/TD]
[TD][/TD]
[TD="align: right"]306[/TD]
[TD="align: right"]330[/TD]
[TD="align: right"]149[/TD]
[TD="align: right"]350[/TD]
[TD="align: right"]373[/TD]
[TD="align: right"]383[/TD]
[TD="align: right"]384[/TD]
[TD="align: right"]151[/TD]
[TD="colspan: 2"]103 alola[/TD]
[TD="align: right"]208[/TD]
[TD="align: right"]249[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]Fig[/TD]
[TD]Counter[/TD]
[TD]13.3[/TD]
[TD]12[/TD]
[TD]8[/TD]
[TD]0.9s[/TD]
[TD][/TD]
[TD="align: right"]257[/TD]
[TD="align: right"]286[/TD]
[TD="align: right"]288[/TD]
[TD="align: right"]297[/TD]
[TD="align: right"]308[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]360[/TD]
[TD="align: right"]214[/TD]
[TD="align: right"]386[/TD]
[TD="align: right"]185[/TD]
[TD="align: right"]202[/TD]
[TD="align: right"]217[/TD]
[TD="align: right"]232[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]Roc[/TD]
[TD]Rock Throw[/TD]
[TD]13.3[/TD]
[TD]12[/TD]
[TD]7[/TD]
[TD]0.9s[/TD]
[TD][/TD]
[TD="align: right"]299[/TD]
[TD="align: right"]337[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]338[/TD]
[TD="align: right"]185[/TD]
[TD="align: right"]213[/TD]
[TD="align: right"]377[/TD]
[TD="align: right"]74[/TD]
[TD="colspan: 2"]74 alola[/TD]
[TD="colspan: 2"]75 alola[/TD]
[TD="colspan: 2"]76 alola[/TD]
[TD="align: right"]218[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD]Wat[/TD]
[TD]Waterfall[/TD]
[TD]13.3[/TD]
[TD]16[/TD]
[TD]8[/TD]
[TD]1.2s[/TD]
[TD][/TD]
[TD="align: right"]119[/TD]
[TD="align: right"]130[/TD]
[TD="align: right"]160[/TD]
[TD="align: right"]230[/TD]
[TD="align: right"]319[/TD]
[TD="align: right"]342[/TD]
[TD="align: right"]365[/TD]
[TD="align: right"]382[/TD]
[TD="align: right"]350[/TD]
[TD="align: right"]151[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD]Roc[/TD]
[TD]Smack Down[/TD]
[TD]13.3[/TD]
[TD]12[/TD]
[TD]7[/TD]
[TD]0.9s[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]