•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is VLOOKUP really the best method to match data cells for products?
Our take
Are you struggling with VLOOKUP to match product SKUs across your spreadsheets? You’re not alone—many users find this function confusing when trying to track sales data effectively. The good news is that AI-native spreadsheet technologies can simplify this process, offering intuitive solutions that transform how you manage inventory. If you’re ready to streamline your data matching and make informed reorder decisions without the frustration of traditional methods, keep reading. We’ll break down how to achieve your goals with clarity and confidence.
I've tried to many times to understand how to use VLOOKUP and I just can't seem to grasp it.
I've got a list of products with skus in one sheet. In another sheet, I have data for SOME of those same skus (spectifically, skus that are the slowest moving) that tells me how many days it's been since that sku sold.
I want to create a new row in the first spreadsheet with a column denoting how many days it's been since that product sold, so that I can then use that spreadsheet to make a reorder, but not reorder items that haven't sold in X number of days.
I've tried many times to understand if VLOOKUP is right for this, but again, I just end up frustrated because I can't seem to understand what it does, or how to get the data I want from the specific column I want into the matching column for the correct sku on the other sheet.
Would anyone be able to help me understand how to do this?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Inventory Audit using XLookup w/ multiple criteriaI've been working on a spreadsheet to keep track of some inventory. It has how many units entered and exited each day, for each item. Using this information, I have then compare it to the list of in/out inventory sent to us by a third party, basically to confirm that our numbers and their numbers match. This is where I'm struggling. I can't seem to find an efficient way of comparing these numbers that works. I've tried XLookup and Nested formulas, Index Match, etc and nothing seems to be working. I need the "total" numbers for each day from the first image to go into the "Double Check" column on the second image, matched for the item and date. I'm not sure if it's an issue because some is horizontal and some is vertical? Would love if anyone had a solution or better method to do this, thanks! Edit for more info: the image with the inventory, the "in" and "out" columns both pull data from a separate sheet that has all of the relevant information and then the "total" column is a formula that just sums the in/out with the previous days' inventory count. https://preview.redd.it/0r74aaf1nang1.png?width=1225&format=png&auto=webp&s=b024c5dad6c53315bfc91199aed1585e74512cba https://preview.redd.it/z799p9f1nang1.png?width=535&format=png&auto=webp&s=2df6c58a1f26c43d0d0b37801eb5d03cc05bdbfd submitted by /u/Fluffy-Reaction6723 [link] [comments]
- Need to return a value based on two different search criteria, multiple lines, VLOOKUPHi All, I have a report that I run at work that doesn't come out in a way that makes it easy to work with in an excel spread sheet. The best i can get it is a txt file that when pasted spreads values into different cells. I use VLOOKUP in other sheets to find one value and return another value in the same row. I don't know how to (or if it's even possible) to do this with multiple values on different rows. Could really use some help. I need some sort of VLOOKUP/XLOOKUP type of formula that does the following: -Searches Column A for a specific value -Then Searches Column B (Below where Column A value was found) for another value -Returns the value in Column C (Same Row as B) based on the value from B I'm pretty much stuck using Excel for this as my company doesn't allow outside/other programs to further organize the data. Macros may also be an option if anyone knows any. Thanks in advance with any answers. submitted by /u/QuandoOmniFluncas [link] [comments]
- Complicated Lookup Function - Pulling Info From One Sheet To AnotherMaybe 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! SHEET 1 SHEET 2 submitted by /u/SameCoffeeEveryDay [link] [comments]
- How to automate updated SKU code in spreadsheetI have a spreadsheet that has a list of sku codes for products across multiple sheets. The sku codes that are on the sheets that I have currently are “in house” (basically a place holder) sku because we use these templates for multiple vendors. We have a vendor that provided an excel catalogue of sku that are specific to their company. Basically I need a way to link my sheets with their information. So if my sku for drywall is 1234 currently but the sku they use is 4567 I need my sheet to update any sku that is 1234 to 4567. The one master catalogue of skus will be spread across tens of spreadsheets. Master catalogue is every material used in home building vs my sheets are broken up by category. Does anyone know what tools is can use to accomplish this? submitted by /u/CJ_4654 [link] [comments]