lookups

Hi I had some answers to a post a couple of weeks ago which were amazing, and have solved that problem. But the person I was doing it for has asked for one step further. Old post is here (I still can't figure out how to do the attachment thing - have tried all of them - might be because I'm...

I have two columns of dates and one column with prices. The first column is a day by day sequence across the year (365 cells). The second column are the days when a transaction occurred (eg. 100 cells) and the third column is the transaction price on those days (100 cells). I want to plot the...

Hi again all Not sure where to start with this one, so I'll try to keep it brief. We have two sets of cells on separate rows that contain lookups to a separate table for each row. These return some decimal values. <tbody> Name1 Name2 Name3 Name4 Name5 Table1 Lookup 1.02 1.12 1.3 0.89 0.91...

Hi, I ned to keep a record of stock sold each week in a sportstoreI have two tabs. One called "Weekly Update" and the other called "All Stock". All Columns are named and formatted the exact same on both tabs. I need to do a Weekly update of stock sold on the first tab. This has 7 Columns and...

Hello I have a dataset with about 200 different post codes spread across 6,000 company names. I want to find out how many companies are in each post code. how should i do it? hopefully, my end product is a bell curve distribution chart..

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...

Hi all, I am working to automate as much of a report as possible. The data will be exported directly to excel, and the data sheet will be manipulated to create a main table that drives all summary views. Originally, I planned to use the indirect function to make the lookups simpler, but haven't...

Hi, Does anyone have a clue to why my look up is not find the correct data? On my spreadsheet in column D I have a list of media (ie CAGE, PALLET, TOTE etc) and in column E I have a cumber which references what row they are in on another tab, I then pick which media by a drop down box and then...

Hi I am trying to put together a temporary picking form and are currently having some issues and hope someone can help. I have currently 3 tabs Tab 1 is the main tab that will be my temporary pick sheet Tab 2 and 3 is where I will have data but this will be all together. I need to identify what...

So I'm not even sure that title describes my needs. I'm putting together an automated pricing spread sheet and I need help with the last row... so I've got two tables that need to be looked up by earlier inputs. if the process is 'X' I need it to look at one table, if its 'Y' I need it to look...

Hi All, I am trying to create a VBA code to do the following task: 1. Look up a value on active sheet. 2. With that value, look in coloum "B" of sheet "Database". 3. Change the Value of a Cell to the Time in the same row but a different column on that sheet. I have this so far, but it goes to...

Hi I've made an example of my issue and tried to keep it as simple as I can. Let's say there has been exams and children get their grades (in Sheet 2): Name_____Subject____Grade____Comment Tom______Geography__G_______Poor Tom______Art________A_______Great Tom______English_____B_______Good...

Using the Federal Reserve Bank of St. Louis' Add-In, I am able to download historical rate data for multiple different securities (10-Year Treasury, 3-Month LIBOR, etc.) This is incredibly useful because I can update this data with by simply running the macro and it gives me all the historical...

Hello everyone, I am having major issues trying to determine if there is a way to calculate a certain function. Backstory: I have a list of individuals in a spreadsheet who appear repeatedly every time they make an error in a specific database. I report this information to an executive who...

Hello all, new here bear with me:</SPAN></SPAN> I have a main inventory spreadsheet with 2 columns: A is for Part_Number, B is for location. This sheet hase 1000s of lines, also, there will be duplicates in each column as there are certain parts in multiple locations, and certain locations...

I'm trying to search for data using a referenced cell and on a different worksheet return the value in the row below in the proper column. On the first worksheet the referenced cell's value is 107, I want to look at the second worksheet and find 107, look across the columns to a specific column...

I am looking for the cleanest way to sum everything in one column of a worksheet that meets the criteria for "Revenue" , or "Expense", my revenue column could actually have 10 or 12 line items so I am looking for the cleanest and shortest formula to do this. Thanks so much for any help you can...

Hi all, I'm really struggling with this time-wise, though I know it can be done. I have two workbooks, one with my data, one with a report template. For simplicity, I've put some sample data from the data workbook in a separate sheet of the report workbook (attached if this is too confusing to...

Hi I've run into a bit of a challenge with dates. Essentially I'm have a bi-monthly calendar with date ranges appearing every two months for a 12 month period. I have two tabs, the first (tab A) contains all the date ranges and an entry for a specific date that doesn't correspond to the range...

Hello, This is my first post and I hope I can articulate my question well. Basically I have a spreadsheet I have to reconcile every 2 weeks. in one column on my target spreadsheet I have city stations such as: ABE ACV ORD I need information from another spreadsheet that has a column with city...