two dimensional formulas

[jsflbot]

Hello!

I'm trying to do a two-dimensional formula by combining the VLOOKUP and MATCH functions. What I'm trying to do is to have the formula fetch from the raw data (another tab); look up the UPC code and then see if that upc has sales under a specific store. UPC's are listed vertically and stores are listed horizontally, so I'm trying to find a match.

RAW DATA spreadsheet/tab:

	A	B	C	D	E	F
1	Item Description	UPC	Miami Beach Store	Plantation Store	Coral Store	Jenkings Store
2	Red Dragon	005	$4	$10	$65	$10
3	Blue Dragon	004	$5	$4	$9	$50
4	Yellow Dragon	003	$4	$1	$6	$9

<tbody>
</tbody>

This is the formula that I'm using but its coming back as #N/A...

=VLOOKUP([@[Top 5 SKU''s]],'Raw Data'!A2:F4,MATCH([@Store],'Raw Data'!C1:F4)+1)

	A	B	C
1	Store	Top 5 SKU'S	Sales from Raw Data
2	Miami Beach	there's a drop down menu here	=VLOOKUP([@[Top 5 SKU''S]],'Raw Data'!A2:F4,MATCH([@Store],'Raw Data'!C1:F4)+1)
3	Plantation	there's a drop down menu here
4	Coral	there's a drop down menu here

<tbody>
</tbody>

• TOP 3 SKU's refers to a cell where I have a drop down menu listing the top 3 sku's, so I would select a sku and hopefully cell C2 would pull that data that I need from the Raw Data spreadsheet

Any help is appreciated, thanks!!

 

[Andrew Poulsom]

Close:

=VLOOKUP([@[Top 5 SKU''S]],'Raw Data'!$A$2:$F$4,MATCH([@Store]&" Store",'Raw Data'!A$1:F$1,FALSE),FALSE)

 

[jsflbot]

I tried it Andrew and it did not work...

 

[Andrew Poulsom]

In what way didn't it work? I tested it with your sample data before posting.

 

[jsflbot]

Now it did, sorry Andrew! I was missing a parenthesis