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

[jaycre8tive]

Hello,

I have a workbook that's is pulling pricing data from 3 others sheets, On one of the sheets, the data is formatted into rows and can't seem to get it to work using vlookup.

Main Sheet.png


I need to take data from the table below and have it display into the "site 2" column in the table above. I can't seem to figure out how to make that work with Vlookup, perhapse its not the best formula to use. I'm a little lost, any help would be greatly appreciated

Source.png

[6StringJazzer]

Welcome to the Forum jaycre8tive!

As a new member, please take the time to review our rules. There aren't many, and they are all important.

Rule #1 requires good thread titles. Your title didn't tell us anything at all about your question. I have updated for you because you are a new member.

Also, an image attachment has very little value. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that. It will be much easier to understand your problem if you provide your file. This allows us to see and experiment with your data, layout, formulas, code, and possibly attach a file with a completed solution. If you are looking for formulas to produce a desired result, it helps if you create a mock-up of what you want the result to look like. Otherwise we would have to build something from scratch, trying to guess what you want it to look like.

The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

Your problem is probably straightforward but you have not included nearly enough information to help.

What VLOOKUP formula did you try?
What result did you want, and what result did you actually get?
You have four blocks of data that each have Site 2. How do you determine what data should go in each of those four blocks?
Your data table has nothing to identify which site the data is for. How to you determine which data is for Site 2?

[jaycre8tive]

Hello, Thank you for the reply, I attached the workbook, 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.

Let me know if this is clearer,


I appreciate the help, sorry about not reading through the rules

[finalazy]

on the main sheet for site 3 column, you can use this

=IFERROR(INDEX('Site 3'!$A:$J,MATCH($A3,'Site 3'!$A:$A,0),MATCH(SUBSTITUTE(Main!C$1,"ricing Level ",""),'Site 3'!$A$1:$J$1,0)),"")

copy paste for all pricing level site 3.


For the site 2, how do you differentiate which of it belows to Pricing Level 1, Level 2, Level 3 etc .. ??

[jaycre8tive]

on the main sheet for site 3 column, you can use this

=IFERROR(INDEX('Site 3'!$A:$J,MATCH($A3,'Site 3'!$A:$A,0),MATCH(SUBSTITUTE(Main!C$1,"ricing Level ",""),'Site 3'!$A$1:$J$1,0)),"")

copy paste for all pricing level site 3.


For the site 2, how do you differentiate which of it belows to Pricing Level 1, Level 2, Level 3 etc .. ??

There displayed in order: I added 1 more column to show Example.png

[finalazy]

try pasting this on site 2 column on main sheet for pricing 1.

Then copy paste for the rest.

=IFERROR(INDEX('Site 2'!$D:$D,MATCH(1,INDEX(('Site 2'!$A:$A=Main!$A3)*('Site 2'!$E:$E=SUBSTITUTE(C$1,"Pricing ","")),),0)),"")

[jaycre8tive]

Thank you a million, that worked like a charm!

[finalazy]

You are welcome. Glad it work out for you.