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

B

Bratamoli

New Member
Joined
Jul 20, 2018
Messages
19
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]
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sort by date Sort by votes
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.

Bratamoli said:
[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]
Click to expand...
 
Last edited:
Upvote 0
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
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
Match/Lookup separate tables into one column
2
Replies
12
Views
1K
Skybluekid
Skybluekid

Forum statistics

Threads
1,224,823
Messages
6,181,170
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top