Looking up data in one sheet for a different layout on another sheet

[jaycre8tive]

Hello, I attached the workbook,
https://nofile.io/f/hV3NG1FvKkS/Data+Sample.xlsx

I removed most of the data just to drill down to the core issue.

The Problem that I'm having is:

I have 3 sheets on that workbook

Main - Site 2 - Site 3

I'm trying to pull data ( prices ) from Site 2 & Site 3 into the Main sheet, The data on the "site 2" is formatted into rows
while the data from "Site 3" is formatted into columns.

The Vlookup function was working but it seems to be returning N/A.

Any assistance is would be greatly appreciated

 

[mumps]

Change the B2 in the formula to A2.

 

[jaycre8tive]

Change the B2 in the formula to A2.

Hey sorry i did that already, I uploaded the wrong file, it still seem to display n/a. I read that the data need to be in text format i made that conversion and i still get an error.

 

[mumps]

When I tried the change in the formula in your file, it worked properly.
=VLOOKUP(A3,'Site 3'!A2:J2,7,FALSE)

 

[jaycre8tive]

Would you happen to know a way to input the data from the "site 2" sheet as its formatted into rows? thank you

 

[mumps]

Could you upload a file with a sheet showing what you would want the data from the "site 2" sheet to look like?

 

[jaycre8tive]

Could you upload a file with a sheet showing what you would want the data from the "site 2" sheet to look like?

Here is a revised file, http://s000.tinyupload.com/?file_id=19646228205973368961 There are more products in the sheet i just removed them to simplification purposes

Thank you

 

[mumps]

Will there always be 4 Pricing Levels, Quantities and Cost and only one Number and Name?

 

[JRenn]

Change C1, G1, K1 etc to Level 1, Level 2 etc - take out "Pricing" on the Main tab.

The use the following in the cells for Site 2 on the Main tab: =SUMPRODUCT(('Site 2'!$A$2:$A$5=Main!$A3)*(('Site 2'!$E$2:$E$5=Main!$C$1)),('Site 2'!$D$2:$D$5))