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

	A	B	C	D
1	PO	BRAND	PRODUCT	EDITION
2	00001	JESSUP	24010	3RD
3	00002
4	00003
5	00004

<tbody>
</tbody>

*Column Headers(ROW 1) - can NOT move/change/rename.

Data

	A	B	C	D	E	F
1	PO	AREA	VERSION	TRADEMARK	ITEM	COUNTRY
2	00001	NA	3RD	JESSUP	24010	US
3	00002	EU	2ND	JESSUP	24010	GB
4	00003	NA	4TH	LEGACY	20003	CA
5	00004	AS	5TH	LEGACY	20003	CN
6	00005	EU	1ST	JESSUP	24010	FR

<tbody>
</tbody>

**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.