Match Related Problems & Solutions

16 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 16 of 16
[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...

1


Ask Question