index and match

Hello, I have the following Excel data and I would like to return the repeated values found when the user searches for keywords. It can be a formula and/or VBA code. To be considered: 1. Column A and B have fixed values. 2. Column C and D are the keywords that the user will enter (not...

Hi, I've been researching below issue for couple of days with out any luck of a solution: I am trying to create a formula which return the last value in a row based on a client name example: Column A (client name).......Column B (Data1).......Column C (Data2).............Column D...

Hi, I have 2 spreadsheets. The first one has 2 columns Column 1 is a 'Task Number' Column 2 is a 'Product Number' On my other spreadsheet i have the Task numbers running in each column and the product numbers running down the rows to form a sort of empty table/matrix. How can i look up the...

Hi, On a tab I have the information below. Loc Model E76 WS-C2960G D71 PROLIANT DL360 G4 E76 PROLIANT DL360 G7 E76 PROLIANT DL360 G7 E76 PROLIANT DL360 G5 A80 PROLIANT DL360 G5 When I am looking for the value which is link to the value E76 I get WS-C2960G. But I would like to...

I trying to develop a formula to return a variance amount from using a vlookup, hlookup, match or index. The is the tab in which the formula would be entered. <colgroup><col><col><col><col><col><col><col><col><col span="6"></colgroup><tbody> Date Name Variance 02/27/15 Mike (99.95)...

Hello Mr Excel Community My problem is as follows. In Sheet1 column B:B I have a list of two symbol initials than can comprise of letters and numbers. B:B EK BR SK TG TK ETC.. In sheet 2 column A:A I have a list where the first two values will comprise of the values listed in B:B. I then...

Hi Everyone, I am working on an Excel Workbook that has 14 tabs or worksheets. Worksheets are "Summary" "Year End 2014" and each month... ("Jan" "Feb" "Mar" etc...). At the end of each month I get a report with all of our sales that I copy and paste into the corresponding month's tab. On my...

Hi, I want to write a formula in a cell on a worksheet using <acronym title="visual basic for applications">vba</acronym>. The formula holds an path name for a certain folder. I can get the data out of the file in the folder, but it seems that excel doesn't find the file (File_Name), since I got...

Hi, I'm really struggling with this so I hope someone can help me! My spreadsheet shows all commission payments on individual insurance policies, each of which has a unique number. There is one payment per policy per month. My excel spreadsheet has two sheets. One sheet, "raw data" contains...

Hi There, I have a problem I need to not only return the highest value per sales rep but the name of the deal. <tbody> Opportunity Name Opportunity Owner Unique Sales Price Arriva_Mittelstand Andrea Junge 130.000 Siemens-CIT-ARIS Design Server Denis Wachsmuth 17.600 Telefónica Alfabet...

I hope someone can help me with this. When I manually enter this array formula into a cell using Ctrl-Shift-Enter, everything works fine: =IF(ISNA(INDEX(Log_WK!A:A;MATCH(SLA!B5;IF(VLOOKUP(E5; Correspondance!A2:B173; 2...

This is my first post - I've been lurking for a long time and it seems I always need an answer right away, so I've never actually tried this, so here goes! I'm sorry if it's lengthy... I see how frustrating posts are without enough detail so I may overdo it a bit. My Specs: Excel 2007, Windows...

I have a formula that looks up the completion date of a course someone took. I want to add a fourth criteria so we can use this Course Entry Table for years to come. Can someone show me how to do this? My Entry table has 4 columns: Date, Name, Course, Pass_Fail My Completion Log has all of...

Hello All, I am Not a excel genius. I am trying to make a file in which i canauto fill information of employee on one single page. I have one file (Workbook 1)which has 52 tab (Each weekending Sunday). I want to make a formula in which if i put week ending and Employee number it gives me...

EXCEL VERSION Excel 2013 (15.0.4631.1000) BACK STORY I create weekly reports, reporting activity based on a 'Week number' defined by a custom year. Custom year = 01 SEP - 31 AUG. Each week within this custom year is defined by a week per row in a named table. E.g. Monday 02/09/2013- Sunday...

Microsoft Office Home 2010 Dear Excel Gurus – First and foremost, I bow to your expertise and thank you for any help you may be able to offer, as I am way out of my league with this question. Description: I am trying to make sense of a massive data dump I have received. The first image below...

I have data on sheet (1). Column B have date. I want this data to go on sheet April, may, jun and so on, depending on their date in b column. Please help me how to do this. I want to use index and match formula preferably.

I have a table that contains payment for several contracts between different dates, with contracts appearing on more than one line (but not with over lapping dates). I'm trying to using index & match to sort these rows into one row for each contract. However when more than one contract is held...

So, I have a file with values in one column (Column 1) and values in a second (Column 2). On another sheet I have a list I need to make from those two columns (Column 3). Column 1 has info as : 201 - 1 201 - 1 202 - 2 202 - 3 etc. and is random but in chronological order, there are...