**[Solved] Add 2 additional criteria (customer name&location)** *Summary*: The below formula allows me to pull in data based on a specific item number and column name. I need to add 2 more variable criteria that is located i...

**Can this approach be optimized?** *Summary*: Hello all Can the following solution be optimized somehow or am I stock with this very slow working array formula? I have a sheet with the following d...

**[Solved] I have the wrong Instalation disc. It is in the wrong sleave** *Summary*: The product Key is correct on the sleave. The disc inside the sleave doesn't match the product key. how can I find the product key for the disc? I thi...

**[Solved] =INDEX Problems with Data** *Summary*: Hi Can anybody help with this problem "=INDEX($G$5:$G$11181,MATCH(K6,$G$5:$G$11181,0)) This works except when you enter a new number in K6 it doesnt s...

**Can Help With an =INDEX** *Summary*: Can anybody help so I can put this to bed before xmas day "=INDEX(A2:A2500,MATCH(A2,L2:M2500)) There are 1712 email address's in Col A apprearing som...

**Finding Two closest match from array** *Summary*: Hi Can you tell me how can i find closest two match of a number so that i can interpolate its vlaues eg A B 2 .22 4 .33 6 .55 8 .77 ...

**[Solved] Possible Formula to match similar characters in verious colm** *Summary*: Hello, I am trying to figure out a possible formula in Excel that can match similar characteristic. For example, I have two columns, Column "a" & "b"....

**[Solved] Sort & Match one column of data with columns of data** *Summary*: Match data in spreadsheet by sorting. Have a spreadsheet I need to import into accounting program. Amazon uses ASIN numbers and everyone else uses ISB...

**[Solved] Vlookup + match help** *Summary*: Hi, I am trying to populate a column based on data available in different columns. The forumla I came up with is as follows: =IF(ISNA(VLOOKUP('By Ite...

**How do I match up two sets of data in excel ?** *Summary*: Hello, I have two sets of time data in the format dd/mm/yyyy hh/mm/ss. I need to match them up to one another as one set of data is taken onc...

**Directory Path Match Certain Pattern** *Summary*: Hi All I am very new to Dos Script, however I have a task on hand which I believe will be most efficient to execute in Dos Scipt(.BAT). I will run thi...

**match data and return another data** *Summary*: Hi. I have a problem here. I would like to match a name between sheet 1 and sheet 2 of my worksheets. Let says if a name on sheet1 is in A1, and the ...

**Excel: Comparing multiple sheets to a master** *Summary*: I have a workbook that has 11 sheets. The first is an asset list of 6000 items with serial numbers (master list). Each other sheet has a few serial nu...

**Change Cell Color** *Summary*: I need to change a cell color when the data in the cell matches the data in a range of cels on another worksheet. EXAMPLE: Sheet 1 cell A2 is empty ...

**Text List in Excel** *Summary*: Hi, Using Excel for mac 2004, version 11 In column 1 I have a list of schools that currently receive product A. In column two I have a list of scho...

**Vlookup, IF, Match, ISNA** *Summary*: Hi, I need assistance on how to create a MS Excel formula which matches criteria from two different MS Excel files. i.e. I have columns named Part N...