multiple criteria lookup

Hi, I am using Office 365. I've tried the Concatenation approach and using a Vlookup, but I think it isn't working because the cell contains both numbers and text. I spent a while trying to sort that out, but I think my files have formatting issues, even after using the TEXT function, so would...

I have this formula, I feel I am making a very small mistake, but I keep receiving the #N/A error. I've been working on trying to find a fix to it for about 2 days now, any help would be greatly appreciated. 1 2...

I have below formula I can't seem to get to work and can't find anything online about it. A brief explanation of it is: If data from B5:B50 is equal to AUTH!A:A, it'll continue otherwise it will return blank. <It only needs to match one instance of that data, not every instance of the data. > If...

Hello, I am trying to have the below code entered into Excel via VBA but am getting the "Unable to set the FormulaArray proprty of the range class" on the first line (and I'm assuming I'd continue to get this error on all the other subsequent array formula lines). Any suggestions on how I...

Hello I am trying to create some lookups with multiple criterias see the links for screenshots of what I am trying to do. https://photos.app.goo.gl/mAuxs438hFUOjQZw1 https://photos.app.goo.gl/C9em194jvajqCEfy2

I am trying to use a Range VLOOKUP based upon the criteria of color in this example. I have another set of data but used this example for simplicity and business reasons. But I need to use the table range that corresponds with the color. I have a lot of values so hard coding is not an option...

Table 1 <tbody> A B C D E F G 1 Pre-planning x X 2 Plan x X 3 Config & Pro X 4 Title Level Oganization 1 2 3 4 Project Management Team 5 Project Lead Directory Company 1.00 1.00 6 Testing lead Manager Client .50 1.00 Finanical...

hello community, I'm looking to extract values from a spreadsheet based on multiple data. I used the following tutorial, which led me to create an array that worked perfectly for creating outputs based on 1 condition, but my attempts to expand it for 2 criterion haven't worked...

Hi Everyone - I am stumped on building this formula out to incorporate multiple criteria across multiple tabs. I have spent hours searching for a similar problem and I cannot find anything that works. I hope someone can help. Currently, I have 2 criteria and only 2 tabs to look through, BUT...

Hi everyone I have been looking at this all day and I cannot fathom how to create a formula for this. I have multiple criteria - I am essentially looking for a way to pull data taking into consideration the following: I need to find the actual (or target) value for mexico (country) for sales...

HI there I am tracking the daily activities of staff to see where they are spending the majority of their time and where their pain points are. I have a tab full of data that has been entered in intervals and i want to be able to count the differerent users activities across the whole time...

Hello, Good day. I am trying to extract a specific prize for our raffle. The prize that a customer gets depends on the combination of purchased items. We have 38 prizes to give away thus 38 combinations of items. I just can't seem to make this formula work...

...That baby might help me solve this problem, or maybe not? Excel Gurus I'm seeking your wisdom! I'm trying to create a spreadsheet that will take a variable amount of inputs which are customer ID's, search a file, and return the sum of all of the sales of those ID's in a particular...

I am receiving a Type Mismatch error and cannot figure out why. I had a Dlookup with 1 criteria, which was working fine. I have been trying to 2 additional criteria which come from the same table to this dlookup, however I keep getting a type mismatch error. Here is my code: M_ID =...

Hi everyone, I was wondering if it is possible for excel to pull out the highest number when the digits are divided by dots. Please note the amount of numbers in between the dots are not constant (although they are always between 1-4 numbers). For example I have a table that looks like...

Hi everyone, I was wondering if it is possible for excel to pull out the highest number when the digits are divided by dots. Please note the amount of numbers in between the dots are not constant (although they are always between 1-4 numbers). For example I have a table that looks like...

I need to do a lookup on multiple criteria. I put this formula together and was happy to see it worked but just discovered it's returning the incorrect value. Here is my formula -- and yes, I am doing Ctrl+Shift+Enter to do this as an array...

I am trying to use VLOOKUP with 2 criteria using 2 tabs. Tab 1 has employe information such as height & age. Tab 2 has the array information. I am trying to find the maximum weight for the height/age. {=INDEX(MALES!A1:AS22|MATCH(1|(MALES!A1:AS22=EMPLOYEE1!F3)*(MALES!A1:AS22=EMPLOYEE!F2)|0))}...

Hello, Can someone help me to figure out a formula that find the closest match based on two criterias? I have two sets of data. The date has to match each other in both sets. The amount may match, but can differ within +/- 10. I want to find the match or the closest match. How can this be...

I am trying to draw some analysis from a long list of different sales made to see how often each client returns to make a new purchase. I have made an array which works for a single criteria, but now I am looking to add a second criteria. <tbody> Company Name 1st Sale 2nd Sale 3rd Sale 4th...