look up data

I have a worksheet that consists of a complete database and I want to create a summarized worksheet. The summarized worksheet will be based on the State that is selected from a drop down list. Here is a sample of the database. So if in the summarized worksheet I selected the state FL, I would...

Dear Experts.. Request for help. Below mentioned please find worksheet. Sheet 1 have data comprising of Program name, commodity and engineer working on the program and commodity. From the table I wish to extract Commodity and engineer working on it and paste it to respective Program tab. "LE"...

Hi everyone, I would appreciate it if someone can help me with this. I have a workbook of 13 sheets. All 13 sheets contain the same information:Activity-Employee Code-Employee Name-Code1-Cost1-Code2-Cost2. I'll show a small example to illustrate my case: I have a table containing all...

I am building a Call Center entry form to make data entry fast for the user and protect the structure of the workbook. My intent is that when a field tech calls in at the start of work the Operator would enter a key field, like the phone number from the Caller ID, onto a User Form. This would...

Looking for a formula in excel, was thinking of an IF with AND or VLOOKUP?? I have a database in Excel that has A B C 1 9/1/98 8/31/00 RED 2 9/1/00 8/31/02 BLUE 3 9/1/02 8/31/04 GREEN 4 9/1/04 8/31/06 YELLOW What formula would I use to take a Date (lets say its...

Hi, I have the below excel file in dropbox. promise it's clean :) I would like a simple formula for a complex task. Do not want to add any columns or sort any data. The data will not be sorted alphabetically in any tab. 1) worksheet "email" has a person's full name in column A (with a space...

I have a slight problem I need help with. I have two data sets that I am trying to cross reference and extract information from. My column are as such A: Number B:Price C: Effective Date D: Termination Date 123 $1 20111226...

Hi There, Here i am once again begging for a solution for an interesting Problem. I receive a system generated file out of which i need to create a report for My Management using Pivot Table. The Generated Report is not ideal for Pivot Table Structure, so i need to convert it to a decent table...

Hi, so I am having some problems... Again! Basically, I want to say - Look in column G, if the value is "pending" return "us", if the value is "In progress" return "them". The problem is that there are about 12 different potential status' in column G which I want to return either us or...

Hi, Basically, I am creating some data and I am a bit stuck. I would like to say: If any cells in column c have the word "Giant" in it (there will be a sentance in each cell but I would like it to pick out the specific word) - Then please paste the whole line into sheet 2. Is this...

This is my problem now: I am using Office 2003 I am trying to use a formula (Maybe a VLOOKUP not sure if it's the best choice) so when a name is entered on the 'Sign Up Sheet' it returns a date that corresponds to where the name was entered and returns the date in the first column of the 'Sign...

I hope someone can help me. I have a construction estimate workbook that works as follows: PO#, vendor#, Item#, Item Description, Price, 1500 7033 2345 2x4x12 3.54 1501 3454 2343 Termite Treat 100.00 The Price...

Hi there. I'm very new to excel and a lot of the answers here are over my head. I'm totally okay with learning what to do, but I just need someone to narrow down what I'm supposed to be looking for. I need to find a number in one excel file: terms will look like this: HD #1423 -blah blah...