match 2 criteria

Hi, I need to look at a range of values that consist of customer name, item # & colors available. I need to know if a specific combination exists in the list. I am using a countifs statement to accomplish this, but I can't figure out the color part. I can't search a range of values to see if a...

Hello! I am a bit stumped here. I am working on a workbook with 2 worksheets and I need to figure out 2 formulas: Worksheet 1 contains (among other data): <tbody> A N O P Participant name <tbody> Month Started (First Session) </tbody> Month Completed (Month of Last Session) Current...

My workbook contains NAMES in A53:A62 (values all alphabets) Further there are 2 ranges: Range1 & Range2 Range1 is V53:AC62; AH53:AK62 (6+6=12 columns) Range2 is AW53:AZ62; BB53:BD62; CF53:CK62 (3+3+6=12 columns) Formulas in Range1 are: V53:Y62...

Hi Excel experts! I have the following table as assumptions: Level Revenue % 1 1,100,000 10% 1 1,500,000 11% 1 1,700,000 12% 1 above 13% 2 1,500,000 11% 2 1,700,000 12% 2 above 13% 3 1,700,000 12% 3 above 13% Then, in different table...

Greetings, I am hoping someone in this forum can help me with this as I am stumped. I need to write an array formula that first evaluates against a vertical column of values and then finds a different value in the row of that vertical value. This sounds simple to do with INDEX - MATCH, but I...

This one is a little complex and I am in way over my head on this one, but have come too far to turn back now. What I have is... On workbook "1" I have tabs named for the inspectors and their order numbers are in column A. Then in workbook "2" each tab contains order details and is named with...

Hey guys, So I currently have a macro button that, when pressed, imports an entire table into sheet11 from a mySQL database. In the same workbook, I have an excel sheet1, that has many of the same columns as the new table in sheet11. I would like to get it where when the macro button is...

Hi Folks!, I'm trying to use the INDEX function combined with MATCH to lines and MATCH to columns. However, for some unknown reason, is not working. The follow link shows the details more accurately. https://www.sendspace.com/file/2o9azy I thank the help and attention of those who can...

Hello, I have a Vlookup Match formula matching one criteria, can someone help me add an additional match criteria? =VLOOKUP($A20,Sheet1!A1:D1000,MATCH(L$8,Sheet2!$A$2:$M$2,0),FALSE) I need to add another criteria to also match against H$8 on Sheet2! i.e. (H$8,Sheet2!$A$3:$M$3,0),FALSE)...

Hello Board, I am using Excel 2013. I am new to macros and am trying to build a macro to perform a index match function as the normal index match function keeps locking up my pc trying to calculate (the amount of rows of data is close to 16,000 at the moment). I have placed a table which is...

Hi, how can I add second MATCH into below function: OFFSET(Sheet2!$BS$1,MATCH(Sheet1!$H$9,Sheet2!$BR$2:$BR$402,0),0,COUNTIF(Sheet2!$BR$2:$BR$402,Sheet1!$H$9),1)) example: If in one field I select Austria, and in second field I select Wien, I want to have in third filed ALL STREAT for Wien...

Hi Excel Warriors, I am at your place to get my solution for one problem. I need value based on two criteria of Column Label. i.e. Take only Row% value from column label ABC...etc. Currently, I am using vlookup & Match formula. but what if the column has two critaria? <colgroup><col...

Good morrow, New member here from Sutton, UK. Having failed to find a solution to a colleague's excel problem I am now looking for some help! My colleague is working on a spreadsheet where she needs to total the number of cells (that being the most important bit) that meet this criteria...

Hi all, after searching all through the forums and posts I could not find a solution to the following problem: I have 2 columns ,A and B, in a table and text strings in C. Each table row A1 and B1 needs to be compared and matched with the text string C:C. Only if both, A1 and B1, are found in...

Hello, I have two sheets in one file. The first is used for a pivot table and the second one is constantly updated with NOTES on each order. I tried to link the NOTES for each product by an Index function but have not been able to get a result. The idea is to use multiple criteria to assure...

In my column B, I have two possible choices, a blank cell or a value that begins with the letter "A". In column C, if the the cell in column B is blank, the corresponding value will say "Submitted". If value in Column B has a value that begins with the letter "A", the corresponding cell in...

Hi guys, The title pretty much says what I need here some sample data (sorry about the random spaces). Bascially where the columns say 2011 or 2012 AND 1, 2, 3. I want to be able to have it index the number below based on the GL number on the left and both the year and period on the top...

Sheet1 is my input ws. In Sheet2, column G5:G9999 & column H5:H9999 if MATCHES EXACTLY with B5:B9999 & C5:C9999 then in column I5:I9999 i want to get D5:D9999 of Sheet1. Ex: Sheet1 B5=LONDON C5=EURope D5=COUNtrY Sheet2 G5=LONDON H5=EURope then I5=COUNtrY (Answer) Pls how to accomplish it?

A1=MAP1 B1=MAP2 In C1, I get following values thr' formula i.e. either C1=MAP1 or C1=MAP2 or C1=#N/A or C1=null (""). D1 should generate 1 if C1=MAP1 (i.e. A1), 0 if C1=MAP2 (i.e. B1) else null (""). D1=null if C1=#N/A D1=null if C1=null ("") Even if A1=blank, D1=null or if B1=blank...

2 cells contains values (alphabets, numericals & alphanumericals). FIRST VALUE & SECOND VALUE respectively. In 3rd cell,THIRD VALUE. Answer required in 4th cell as: get 1st cell, if FIRST VALUE=THIRD VALUE get 2nd cell, if SECOND VALUE=THIRD VALUE else return a null "". Even if FIRST VALUE or...