look up

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hello everyone I am going to try and put into words what it is that I would like to do. Hope it makes sense? I will try lol. Although I’m not sure how to categorise what it is I...

Hi Everyone, I'll try to explain the more clear I can what I need to do, hope you can help me! ;) I have a table as follows: <tbody> A B C D 1 1,000 * -37.5% -37.5% 2 2,500 N/A 3 5,000 N/A </tbody> The column A is a list of amounts from which we can choose from a drop down list...

Hello all, I'm looking for a formula that I can put in BA2 in a sheet called Data, and copy the formula down the column. If Data AE2 is blank, Data BA2 should be blank. If there is a number in AE2, the formula should look for the matching number in another sheet called Index, in Index column...

I am trying to build a holiday tracker. I need to have a worksheet that, on the first tab, allows the user to fill in details such as: name: day: month: I will then have 12 tabs with each month of the year. Each tab will have a grid with 1-31 (or however many days are in that month) at the...

Hello, I would like to write a formula to return a value from a coulmn that relates to an array within which my lookup value exists. Confused? See the tables below: <tbody> ID V1 V2 V3 105 27 3 149 107 596 81 30 109 12491 68 2 111 19 3 1 112 73 11 16 </tbody> <tbody> Rank...

Hi all :) I have two worksheets, one named Data and one named Index. In column G of Data, there is an index number. In column G of Index, there is a list of special index numbers. In columns A:F there is information about each special index numbers. What I need is in Data, if the index number...

I posted previously on here with no luck. I have a large data set that I am trying to bounce a small data set against using a look up. I thought that perhaps INDEX or MATCH would work, but so far I have yet to find a good result. Below is a sample of my data set: Column A: Number Column B...

Hi, I need to know how many values in a column match my criteria: Column a:a 1 2 3 4 5 6 7 8 9 10 Column b:b S D T S S S D D D T I need a formula that will go through column b and count how many times the following values occured consecutively. S D answer: 2 S D T answer:1 D...

Hello everyone, Look up item, return earliest date and item -- Excel or Access version: Excel 2010 Computer operating system: Windows XP Sample data: "Excel WorkbookEF1DateEmail21/1/2010jonathan@gmail.com32/2/2005jonathan@gmail.com46/3/2004jonathan@gmail.comCombined " Formula(s)...

The raw data I am working with is in the following format: <TABLE style="WIDTH: 145pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=192 border=0 x:str><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><COL style="WIDTH: 89pt...

I have excel sheets. Normally when we Vlook up, we use the following formula VLOOKUP(A4,'HCV TL'!A3:R12,2,FALSE), where 1. A4 is the look up value in 1st sheet, 2. 'HCV TL'!A3:R12' is the look up range in 2nd sheet 3. 2 is the column number from which the value is to be returned 4. FALSE is for...

In Excel 2007, I am working on a Loan Portfolio Report. The report compares all loans (number, officer, amounts, etc.) each Monday with the same information from the prior week. It is important for me to be able to show which loans are new (not on the prior week's report) and which are gone (on...

Hi, Please see attached files at the following links for more detailed info and a sample sheet. sample sheet word document I would like the following things to be done using a macro in real-time. (It is impossible to do with just regular excel functions) So if the workbook is open I...

Hi there, I have a spreadsheet that has 2 different product description that have been matched and a single price. I would like a formula that enables a new order spreadshhet to look up the price on the master spreadsheet and bring it into the order spreadsheet. Is this possible please ...

Hey guys, first post....hoping you can help. I have a list of email addresses on one sheet and in another sheet a column of contact information that has email addresses embedded as part of the text strings in each cell. What I need to do is use a formula to look up if the email address on my...

I have a roster of users who have been assigned a specific role (columns) for a number of different dates (Row). What I'd like to get is a full list of all users, and their role and date for every entry in the roster. I need to provide each user with their 'personal task diary' and I cannot find...