look up

Hello all, I am new to the site and looking to learn how to work more efficiently using excel formulas. Need help looking up which client deposited funds to our account. In our BANK DATA we see the account number or a reference from whom the transfer is from and I usually just copy the number...

Hello everyone! I have an easy one, I hope, for you! I have a vertical list of data (years) in cells A2:A19 on Tab 2 I have a horizontal list of data (years) in cells C5:T5 on Tab 1 I have a horizontal list of data (sales) in cells C6:T6 on Tab 1 I need an equation that does the following -...

Here is an example data set - a series of cash flows A1: 0 A2: -50 A3: -25 A4: 50 A5: 80 A6: 100 I need the following... In the first cell (B1) I need to have the first year of cash flow regardless of whether the cell is < or > 0 In the next cells (B2) I need to have an...

Hi, all i need some help with a look up function. I understand the basic principles of how they work , but I cant figure out how to make them work with a date range. My look up data looks like below. I need a function that will take a Date and look within the Start Date and End date to...

Hello everybody :), I got a little excel task to do, however I really cannot get my head around how to solve it, so I hope you guys can help me out. The problem: I have a list of contracts with contract IDs in column A. However, not all of the contracts are completely different ones. Some of...

I have a list of QA Analyst, and a number of how many audits they need to complete. I then have another list of advisors that need to be audited. I want to apply the QA Analysts name next to the advisors names the exact number of times that the first list says they need to audit. I'm not sure...

Hi guys, I was hopeful someone could help me out with a Lookup function (IndexMatch, Vlookup, or Hlookup) for the following data. The objective is to look up what is in column A (Weeks) and find its match in the array F2-I8, and bring the value E1-I1 into column C. <tbody> A B C D E F...

Hello, I am attempting to look up only the sales team names from 2 columns of employee names. I will be using a list of Sales Team employee ID numbers as the look up value to identify the sales team. In column 1 is the first and last name separated by a space. In column 2 there are multiple...

Basically, I have several recipes and I would like to make it so if someone inserts a recipe code/name, it will "look up" and output the list of ingredients. Does anyone have ideas on how I can do this?:confused:

Trying to get a check box, which is linked to the cell concealed behind it, to have conditional formatting so that when the check box is clicked the value 2 cells to the right (which is a partial string) will be highlighted throughout the schedule. I was thinking this could be done by having...

Hi All, I am looking for a macro that will open up a pdf file based on the value of a given cell. The macro will be run as a button, along with some other macros. An example of my data is provided below. <tbody> A B C D E F 1 Code Name Sector Recommendation Transaction Subsequent Holding...

Hi, I'm hoping someone may have an easy solution for this. Below is a sample from a sheet I am working with. What I need to be able to do is look upwards from a row to find the FIRST instance of a value in order to calculate the number of days since the last reset. Below is the formula I have...

I'm hoping someone here can answer this question. What I'm trying to do is set up a worksheet with product information (barcode number, item description, and unit price) to use as a databse and then set up a separate worksheet with invoice information (invoice number, product code, item...

Hi, I need to look up for a range of values in all the available worksheets, and in case there is any matches, then colour the value on the original range. I have tried the following code: Sub Compare3() Dim WorkRng1 As Range Dim WorkRng2 As Range Dim Rng1 As Range Dim Rng2 As Range Dim...

Hello! First time Posting, I've been given a new project at work where I need to look up customers and come back with the customers multiple contract numbers in one cell. As well as Summing their total order quantities in these contracts (of the same product) in a separate cell - While...

I have multiple sheets in my spreadsheet, all named for each of the U.S. states. I'm trying to write a formula that will sum values on the corresponding state page once the user types in a state in cell A2. For example, I have states Alabama through Wyoming, I want to look through every state's...

Hi, I've the year and date in the format 201602 - 201602 coming into cell G23 from another macro. I need a lookup table which will sense the month number from this and then place another value in cell G22 into a tabular column with month headings (Cells C8 to N8). Appreciate the inputs from you...

This one has been driving me crazy!! I'm hoping someone can help!

Hello All, I have a database of information with account numbers, product types and balances. Each account number has only 1 product type and the balance changes daily. I have a "product key" which I have listed the different product categories separated by the product types that make them up...

I am comparing 2 sets of account balances and want to find the account with the largest change in balance from day to day for a specific product category (Personal Accounts) and location (10). The accounts are separated into groups by a product code and location ID. Below is a data sample...