lookups

Working in excel 2010 Looking for a formula which will show if the "Union Notification Date" in cell A2 was received prior to when the work commenced as outlined in "StartDate" cell B2 and "Start Time" cell C2. The closest I can come up with is using: =IF(ISNUMBER(SEARCH(("*B2*"),A2)),"On...

Hi there, i have a list of address in Sheet 1 Column A, also i have a list of only states in Sheet 2 Column A i want to check if the state names in Sheet 2 Column A are present in Sheet 1 Column A below is the example... Sheet 1 Column A 1 Maharashtra, india 400086 Tel...

<tbody> <tbody> Skincare 1500 7 Magazine 120 Cosmo 345 SkinCare Magz 123 HairCare 2300 Hairstylist Mag 124 HairCare Mag 234 Shampoo Guide 453 7 Magazine 340 </tbody> My Questions is if I want to look up the value for 7 magazine, how do I do it? I...

Hi All, I hope you can help with this one.... I want to have a drop down that lists the alphabet ABC, DEF, GHI, etc etc Depending on which i then choose (ABC, DEF etc) i would then like a further list to be available that would also bring back further data. In essence i want to have ABC...

<tbody> Amt Issue Date Exp Date Fee Date From Date To Fee Rate 100000 09/01/2012 07/01/2013 =? 1/1/2012 11/01/2012 0.85% 200000 09/25/2012 10/25/2013 11/2/2012 =Today() 1.00% </tbody> Additional Remarks: Windows 2007+MS Office...

Ok, I cannot for the life of me figure out how to make this work. Essentially, I would like to write something that would take a complex cell value (a text string in this case), compare that value to another table that has "simplified" listings, and return the "simplified listing" based on a...

New Member and not sure how to do what I need excel to do. I am only reasonably comfortable with vlookup, and I think this will take more functions! I manage assets for clients and each month import my client data base on sheet1, which has account number and name of client. On sheet 2, is...

Hi, I have a list of about 4500 parts which I have calculated teh internal volume for. I now need to cross match this volume to a list of programs which have a range of volumes for which they are appropriate. eg: Part volume is 0.2 litres Program 1 range 0 - 2 Program 2 range 2.1 - 4 Program...

This may be a basic question...maybe not. I am trying to build a cost estimator for travel between various airports. My row names define the airport somebody might depart from. Column names define the airport they are going to. The cell that matches up with both the departure row value and...

Hello, I'm hoping someone can help me with the following scenario? I'm using Excel 2010 and got a worksheet that has a score (1 to 10) in column A with the dates in row 1. The values are often quite consistent and are made up of names (not numbers). What I'm hoping for is on another...

All, I want to create a list from a list. Basically I have a large resource model which has a list of individuals (running from A1:A250) currently on my programme. The problem is that these individuals may be within this model more than once as their time is split across deliverables. I...

Hello, I am putting together a form, and I would like that if the use selects a category in a drop down box, then it limits the options in another drop down box as a result of their choice. You see this often on auto insurance quotes, where if you select the make of the car as FORD, then...

I've seen lots of help on how to disallow special characters when using data validation but nothing on how to ALLOW special characters. I have a pretty big spreadsheet that I'm working on that will be pushing the limits of data validation :). I'm really trying my best not to change the names...

I am currently trying to solve a problem where I am comparing two sheets, one with timesheets and the other with rates of pay. What I need to do is create a formula which looks at the person , the date and returns the rate of pay relating to that date, i.e. an exact match on the name but not on...

Hi there I have a template P&L in which I have a hidden column with a unique identifier for each line item that appears. What I need to do is, pull the actual value for each unique line item from a separate Budget file, which is simple if you use a vlookup or sumif. However, I want all of the...

Hi, I am trying to use two values one table as indexes for rows and columns in the other table so that I can get the value at the interesection of these coordinates. This is the formula I'm using but it returns a #VALUE! error...

Here is what I would like to do. I play in a softball league which plays 7 weeks per season. Each Week we play a doubleheader. I want to create team specific stats thus standings but having trouble figuring out how to make the following example work: Excel...

I have two worksheets. 'IN PROGRESS' - I utilize to enter data 'REPORT - IN PROGRESS' - I utilize to create a report for a client. I want column A from this worksheet to report all of the data from the same column in 'IN PROGRESS'. This list changes in length depending on how many...

Hi, I have a range containing a list of parts that are selected according to its length and weight capacity, each having a different reference, like this... col A col B col C col D length(in) ____ min weight(lb) ___max weight(lb)...

Hi, I want to look up two variables (discipline and grade) and return the corresponding rate. Elsewhere in the spreadsheet I'm using drop down (data validation) cells to select adiscipline and then a grade and I want the lookup function to automatically return the rate associated with that...