Complicated Lookup Function - Pulling Info From One Sheet To Another
Our take
Maybe this isn't as complicated as it seems to be in my head, but essentially I'm trying to pull inventory numbers from one spreadsheet into another. However, the numbers I need to pull in Spreadsheet 1 are listed vertically and I'd like that info to be listed horizontally on Spreadsheet 2.
Here is a quick reference of what I'm trying to achieve. I was able to pull the product names to my second sheet using a VLookup function (woo-hoo!) but trying to pull the inventory numbers by location to Sheet 2 is proving... difficult. Very difficult for me, anyway, especially given how large the spreadsheet is and how the info is formatted. Additionally, some products have additional locations beyond what is listed below - for example a few randomly have a location called "EVENTS", so the Shop Names aren't necessarily consistently placed within the table. So it really needs to be a function that looks up the Qty next to the Shop Name listed under the Item #? Is that even possible?
I've color coded what info I would like to pull and where I need it placed (lighter shades = Info I need pulled, darker shades = shop locations I'm referencing). I hope that makes sense!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Xlookup from another page in Google SheetsHello, I'm a novice user and trying to make a spreadsheet to help with work, using multiple conditions from an order to generate a list of needed parts. I'm getting an error when attempting to reference data from a drop down on another page. I've attached a trimmed down example that I can share without posting work info. https://docs.google.com/spreadsheets/d/1UT6k7b7Sqi0mV6L867CS_jSVQXN15ZyDkHa3gPlTgrg/edit?usp=sharing The real document has more of basically variable, but I think part of the complexity problem is the part numbers I'm trying to generate use the inputs in different ways and in different orders for each part, so I'm trying to make a page for each kind of part data and keep a cleaner UI page. There's probably a cleaner way to do this, that may or may not work with all the actual inputs I need to do, but I'll take any and all advice, I'm just a novice at best. Thank you. submitted by /u/Zestyclose_Silver352 [link] [comments]
- Sorting Data from Highest to LowestData Table on Sheet 1: Relevant data range between D:L; Cells are from 5-2000 only Blank Table on Sheet 2: Pre-made data tracker I am trying to figure out - Essentially, I am trying to filling the table in Sheet 2 only using formula's What I am trying to achieve (from left to right based on Blank Table in Sheet 2): - For the Supplier and Total VPs columns, I want to have the sum of VP codes (there are multiple codes and I want the sum of any of these codes per supplier) used for each specific Supplier in Sheet 1; BUT only capturing the top 15 from highest to lowest - For the 1, 2 and 3 columns, I want to have the top 3 codes used for that supplier and if only one code is used, only the top spot will be filled - For the Main Issue column, I want this to be the highest occurrence issue which is pre-filled when entering codes and this data will be in the VP description section of the data table in Sheet 1 I apologise if my clarification is unclear and am happy to elaborate! Thank you submitted by /u/Whatsgood0110 [link] [comments]
- Xlookup with Nested IF - AdviceHi Guys, I'm working on an Excel sheet, and I'm stuck with something that I shouldn't be stuck with!! Basically, I'm creating a Purchase order that I will print/Email to suppliers, I use various suppliers with all slightly different rates for the same product... I've used Xlookup for most of the sheet being the elegant to solve the various requests, but I'm assuming I need an Xlookup with a Nested IF to settle this issue... 2 Tabs are being used: 1st Tab (Price Book)This is used to store product descriptions(horizontally) and there costs from Different suppliers (vertically). 2nd Tab (Purchase Order)This Tab is a print ready form that is simple, However the bit I’m struggling with is the price part. I select the product from a Data Validation List (Price book) which then populates most of the Purchase Order. I then want the price to be pulled through based on the supplier I have selected for that Purchase Order.... Hope this makes sense… submitted by /u/Sweaty_Sprinkles_539 [link] [comments]