•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I think I need Xlookup or index match to find a specific value with multiple criteria in my excel array but it's not working. Any suggestions?
Our take
Struggling to find specific values in your Excel array can be frustrating, especially when you’re relying on complex formulas like XLOOKUP or INDEX MATCH. It sounds like you’re on the right track, but there may be nuances in your criteria setup that are causing hiccups. In this guide, we’ll explore how to effectively structure your formula for retrieving data about your tree farm, ensuring that you can pinpoint the exact information you need. Let’s dive in and unlock the potential of your spreadsheet!
I have a spreadsheet I'm working on for a tree farm. I'm trying to create a formula that returns a value (G49) with the criteria being the specific tree name, the year, and the total trees at the end of the year, but nothing seems to be working across index match and xlookup. Screenshot below. I am using the latest version of windows and Excel. Thank you
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Xlookup is returning "value not available", but only on some cellsUsing XLookup, with 3 criteria ranges. Using the formula: =XLOOKUP(1, (Criteria1_Range=Value1) * (Criteria2_Range=Value2) * (Criteria3_Range=Value3), Return_Range) Some of the cells are populating the answer, but others are coming back with a error. All the cells have matching formats, so its not an issue of conflicting formats. Any help is appreciated. Screen shot, including formula on a cell getting error is included. https://preview.redd.it/zaxd72pgyqzg1.png?width=1567&format=png&auto=webp&s=f11a2bd0795f0ad200eaa947004f15cb05f19c2d submitted by /u/hawkayecarumba [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]
- 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]
- Return value based on word found in string of text in a cell?I am building a spreadsheet to help budget some expenses and am trying to automate as much as I can. I have a table in Column H with a keyword like "Gas" or "Electric" and then a corresponding category in Column I that groups this into something like "utilities". I have a spreadsheet where I export my bank statement and Column B is the vendor and Column C is the amt. I have Column D trying to group all the expenses based on the helper table in Columns H and I to quick and easy organize all the transactions for a month. I made the formula: =IFERROR(XLOOKUP(B3,ISNUMBER(SEARCH($H$3:$H$35,B2)),I:I),"Uncategorized") to try and get a return and it doesn't work just yet. I feel like I'm close but I'm not as familiar with XLOOKUP as I want and I cant figure out what I could use to make return any easier. Is there a simpler way to get a return like this from a string of text or am I missing something with how the XLOOKUP works? submitted by /u/Pmme10doller_psncard [link] [comments]