lookup formula

I am adding values together from 2 different sheets based on 1. date (in its own column) AND 2. if the description contains "AP" or "CD" (In another column) to populate on a summary tab. I have tried the following formulas: For my values containing AP or CD 1. =SUMPRODUCT(('GL...

Please help me below. Hope someone can help me, I have two workbook like below: Workbook 1 As below: <colgroup><col width="72" style="width: 54pt;"> <col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2656;" span="5"> <col width="112" style="width: 84pt...

Greetings fellow pivot table practitioners, I'm trying to link two sets of data. Samples are listed below. I'd like to figure out a formula that populates the "Status" and "Day Status Began" in the top table based on the data in the second table. EX: On 21 Jan 2015, Scott submitted a report...

Hi all, Have had so much help on this forum in the past, and would love for some help and support again! :) I really need help to find a solution for what I need to do: I will try to explain it in the best possible way below... SHEET 1 ______Colm F_____________________Colm N Row 6_COMPLETE...

Hi all I have a pivot table that generates a list of staff that have completed timesheets for eaqch day of the month and the hours booked. The number of entries on each day will vary accoring to whether a timesheet has data on it or not - so for example, on one paricular daythere may be 3...

I have a huge spreadsheet of contact. I am trying to scrub out all the email address that contain an email extensions on my exclusion list. For example @gmail.com and I am trying to use a wildcard character to find all the email address within my table that cannot be contacted. I am unable to...

I am having trouble trying to workout how to do the below. <tbody> W/E 12/04/2014 19/04/2014 26/04/2014 03/05/2014 10/05/2014 17/05/2014 24/05/2014 Rev. 200 200 200 200 200 200 200 Cost. 100 100 100 100 100 100 100 </tbody> I would like to combine a LOOKUP and SUM to say the following...

Greetings! I have a conundrum regarding a bit of data validation that I'm developing. The purpose is to determine if, on a particular row of data, a specific text string exists. The text string could be found in any column past the first. For example: <tbody> Name variable 1 variable 2...

Hello, I have a column of data with: Last name,Company Name-First Name I wanted to create a lookup formula to return only the company name in the adjacent cell. Does anyone know how I would do this? Thank you

Environment: I am using Excel 2003 and self taught in excel and VBA. I am very new to VBA and if pointed in the right direction will learn a topic. However I need direction I have a mockup of a Call Center floor seating diagram called "Seating Chart" Workbook and Spreadsheet. "Seating Chart"...

I am working on an Excel spreadsheet to make sure that everything that has to happen to get a new hire enrolled in benefits happens on time. Our staff are eligible for benefits on the first day of the month after 30 days of employment. (i.e. if the hire date was June 19, 2013 the staff member is...

I have an excel spreadsheet that has 3 Columns: 1) City 2) State 3) Population all on sheet 1. On Sheet 2 cell B1 I want to be able to select the state and display all cities within that state & their population. I would like to have a formula that accomplishes this and it needs to be...

I need to pull a product ID based on if the number of users and a specific product are in a range of values. I tried a few formulas with no luck. <COLGROUP><COL style="WIDTH: 48pt" span=9 width=64><TBODY> ID Users PROD ID ID USER LOW USER HIGH PROD ID A 1 A 1 100 AB1 A 100 A 101...

Hi! I have a part number that I need to look in a range of value in order to have the manufacturing program. The Range I have is like this: Part 1 to Part 5000 is for chevrolet Part 5001 to Part 5925 is for Dodge Part 5926 to part 6000 is for JEEP My list have for example part 4500...

Dear All, I have two tables, in table 1 i have a statement of more than one customers combined in sequential order, in table 2 i have customer numbers vertically placed and dates horizontally placed. i want to use a lookup function which may extract day end balance in front of each account...

Hello all, I am relatively new to the VB code for Excel macro and wanted to get your advise on the following macro.. '=== CODE START === Sub c_SLCodeThisWk() Dim t As Long For t = 2 To 100 Range("AR" & t).Formula =...

Hi, I need to be able to find multiple values where the same thing occurs. This also needs to be able to use subtotal so that if I filter it only returns the names shown. Poor English so I'll use this table to explain: I need to fins any pupils name where they have particular values. So for...

Hello gracious gurus, I need assistance with dependent list boxes. I have reviewed about 7+ videos and cannot find my answer. I need a formula that will show a List Box based on formula. For example, if I select model "CT4-3/8" then, I want to have the "LB_TB_Fifteen_In " List Box choices...

Hi Guys, I have a problem I cant find a solution too. I have a table of stock codes with corresponding price list (exported from Sage), but on another sheet I would like ot lookup an abbreviated code and return the corresponding price. This means searching cells which contain a particular 4...

Looking for a better way to substitute correct words for incomplete spellings in a list. The following works, but if a word is not exactly like I have in the lookup, the replacement fails. In the next column over from C34 I have...