Can the function: MATCH, be combined with OR function???

[k_mak]

Hello All,
New to the forum and kindly request your expertise. Not certain if this question has been posted before.
Specifically, in the function: MATCH(lookup_value, lookup_array, [match_type]), can we combined the "lookup_value" with OR function???
Tried using a VLOOKUP with MATCH; inside the MATCH function, tried adding an OR function as a lookup value...but was not successful.

Summary
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]PO[/TD]
[TD]BRAND[/TD]
[TD]PRODUCT[/TD]
[TD]EDITION[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]00001[/TD]
[TD]JESSUP[/TD]
[TD]24010[/TD]
[TD]3RD[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]00002[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]00003[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]00004[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
*Column Headers(ROW 1) - can NOT move/change/rename.

Data
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]PO[/TD]
[TD]AREA[/TD]
[TD]VERSION[/TD]
[TD]TRADEMARK[/TD]
[TD]ITEM[/TD]
[TD]COUNTRY[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]00001[/TD]
[TD]NA[/TD]
[TD]3RD[/TD]
[TD]JESSUP[/TD]
[TD]24010[/TD]
[TD]US[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]00002[/TD]
[TD]EU[/TD]
[TD]2ND[/TD]
[TD]JESSUP[/TD]
[TD]24010[/TD]
[TD]GB[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]00003[/TD]
[TD]NA[/TD]
[TD]4TH[/TD]
[TD]LEGACY[/TD]
[TD]20003[/TD]
[TD]CA[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]00004[/TD]
[TD]AS[/TD]
[TD]5TH[/TD]
[TD]LEGACY[/TD]
[TD]20003[/TD]
[TD]CN[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]00005[/TD]
[TD]EU[/TD]
[TD]1ST[/TD]
[TD]JESSUP[/TD]
[TD]24010[/TD]
[TD]FR[/TD]
[/TR]
</tbody>[/TABLE]

**Column Headers(ROW 1)
-Columns can be 10 to 50
-Column headers not in the same location
-Column header names can be different... on Summary, column header must be called: Product. On Data, Column headers can be called: "Product", "Item", "Style" or "Model".

Perhaps VLOOKUP and MATCH won't work, so any help is greatly appreciated! Thank you!!!

 

[k_mak]

Hi Dante,
Can the cell ranges: Column F, G, H be on a separate tab in the same workbook?

 

[k_mak]

Hi Eric,
Again...wow

 

[DanteAmor]

Hi Dante,
Can the cell ranges: Column F, G, H be on a separate tab in the same workbook?

How about

Summary
<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">PO</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">BRAND</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">PRODUCT</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">EDITION</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">1</td><td >JESSUP</td><td style="text-align:right; ">24500</td><td >3RD</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">2</td><td >JESSUP</td><td style="text-align:right; ">24010</td><td >2ND</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">3</td><td >LEGACY</td><td style="text-align:right; ">20003</td><td >4TH</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">4</td><td >LEGACY</td><td style="text-align:right; ">20003</td><td >5TH</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Array Formula</td></tr><tr><td >B2</td><td >{=INDEX(Data!$A$1:$F$6,MATCH($A2,Data!$A$1:$A$6,0),MAX(IFERROR(MATCH(Cats!A$2:A$10,Data!$A$1:$F$1,0),0)))}</td></tr></table></td></tr></table>

Copy to the right and then down

Cats
<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">BRAND</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">PRODUCT</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">EDITION</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Brand</td><td >Product</td><td >Edition</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >TradeMark</td><td >Item</td><td >Version</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td > </td><td >Style</td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td > </td><td >Model</td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td > </td><td > </td><td > </td></tr></table>

 

[k_mak]

Hi Dante Amor,
Thank you, thank you, thank you!!!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.