lookup in unsorted table, column and row unknown (No VBA, please)

[Bratamoli]

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.

A1	B	C	D	E	F	G	H	I	J	K	L	M	N
2	Gen	#	Name	CP	Type	Type2	#FM	FM1	FM2	#CM	CM1	CM2	CM3
3	2nd	172	Pichu	376	Electric		1			3
4	1st	25	Pikachu	787	Electric		2			4
5	1st	26	Raichu	2025	Electric		2			4
6	Alolan	26.1	Alolan Raichu	2143	Electric	Psychic	2			3
7	1st	27	Sandshrew	1194	Ground		2			4
8	1st	28	Sandslash	2328	Ground		2			3
9	Alolan	27.1	Alolan Sandshrew	1219	Ice	Steel	2			3
10	Alolan	28.1	Alolan Sandslash	2366	Ice	Steel	2			3
11	1st	29	Nidoran♀	736	Poison		2			3
12	1st	30	Nidorina	1218	Poison		2			3
13	1st	31	Nidoqueen	2338	Poison	Ground	2			3
14	1st	32	Nidoran♂	739	Poison		2			3
15	1st	33	Nidorino	1252	Poison		2			3
16	1st	34	Nidoking	2386	Poison	Ground	2			3
17	2nd	173	Cleffa	620	Fairy		2			5

<tbody>
</tbody>

--------------------------------------------------

A1	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
2	from:	https://pokeassistant.com/main/movelist
3
4	Type	Fast Moves	DPS	Power	Energy	Cast Time		Pokémon
5	Ste	Steel Wing	13.8	11	6	0.8s		277	17	22	85	151	142	149	18	250	227
6	Ste	Iron Tail	13.6	15	7	1.1s		305	306	336	208	34	87	147	148	248
7	Dra	Dragon Tail	13.6	15	9	1.1s		306	330	149	350	373	383	384	151	103 alola	208	249
8	Fig	Counter	13.3	12	8	0.9s		257	286	288	297	308	57	68	107	360	214	386	185	202	217	232
9	Roc	Rock Throw	13.3	12	7	0.9s		299	337	95	338	185	213	377	74	74 alola	75 alola	76 alola	218
10	Wat	Waterfall	13.3	16	8	1.2s		119	130	160	230	319	342	365	382	350	151
11	Roc	Smack Down	13.3	12	7	0.9s

<tbody>
</tbody>

 

[Bratamoli]

All I really need is a formula to lookup the nth occurrence of a value in the unsorted table below (columns "I" through "W") and return the Move Name in column C (and maybe also the 3 character "Type" in column B, if possible).
The 2nd occurrence of "151" (answer: "Dra - Dragon Tail") would be perfect.

A1	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
2	from:	https://pokeassistant.com/main/movelist
3
4	Type	Fast Moves	DPS	Power	Energy	Cast Time		Pokémon
5	Ste	Steel Wing	13.8	11	6	0.8s		277	17	22	85	151	142	149	18	250	227
6	Ste	Iron Tail	13.6	15	7	1.1s		305	306	336	208	34	87	147	148	248
7	Dra	Dragon Tail	13.6	15	9	1.1s		306	330	149	350	373	383	384	151	103 alola	208	249
8	Fig	Counter	13.3	12	8	0.9s		257	286	288	297	308	57	68	107	360	214	386	185	202	217	232
9	Roc	Rock Throw	13.3	12	7	0.9s		299	337	95	338	185	213	377	74	74 alola	75 alola	76 alola	218
10	Wat	Waterfall	13.3	16	8	1.2s		119	130	160	230	319	342	365	382	350	151
11	Roc	Smack Down	13.3	12	7	0.9s

<tbody>
</tbody>

 

[Bratamoli]

Update: I'm trying to see if I can embed an ISNUMBER(MATCH( array formula inside a formula that will look for the Nth "True."
Here's a partial screenshot of what I have so far.

https://ibb.co/jV7X6z

 

[Bratamoli]

For anyone who may need it, I found an answer: https://exceljet.net/formula/index-and-match-on-multiple-columns