index-match

I have a huge table of data. The most important information is Item, Date, Number One, and Number Two. The data is not in order and is constantly being sorted. Right now, I can produce a table that allows the user to pick any random date and see what set of numbers are associated with all the...

I have an excell workbook, find attached. I created a new sheet call "high Value tools":confused: The difficulty i have is i need the too ID's to correspond with the tools and technitian's names in the worksheet titled "ser" how can i do this, i keep getting ref erros using the Match and...

Hi, I've been trying to find anything related to my question but all I get is multiple results that match the same reference. Ex. If a have <tbody> Name Color John Green Dave Red Matt Red </tbody> I would look for red and I would get "Dave" and "Matt". What I am looking for is: If...

Hello All, I've tried searching for my following query but had no luck so starting a new topic. I have the following table <tbody> Col-A Col-B Col-C A-1 B-1 C-1 A-2 B-2 C-2 A-2 B-2 C-3 A-2 B-3 C-4 A-3 B-4 C-5 A-3 B-5 C-6 A-4 B-5 C-7 A-4 B-6 C-8 A-5 B-7 C-9 A-5 B-8 C-10...

Hello Excel specialists, I got number of sheets. In one I have list of invoices and relevant information about them. Second sheet is clients information list and third is list with overdue payments. Below I added screenshots to better understand situation: Invoice List Example: Client List...

I currently am trying to match some transaction data (credit card authorization times and ticket validation times) using time as the primary key (best option I have) to do this, I am using an index match set to -1. the first ticket validation time finds the appropriate match from the credit card...

Hi! I'm struggling with the following problem and would really appreciate some help: 1. I have 2 sheets in my workbook "Key" and "Database". Database contains a 'Index-Match' table, whose source is Key. The formula for a cell in Database looks something like this: =INDEX('Key'!$B$13:$P$104...

Hi, I'm trying to write a macro to gather data from inbox, look through a series of columns to see if the the inbox data is listed (top row) and on a hit, access each row below, one by one to do some calculations. I'm not sure how to approach this. So for example, I want to key in Monday...

Hello, I have created multiple indexes on a single worksheet and I am currently using a Vlookup and indirect to pull the data from the index that is selected by a drop down box on another worksheet. The value being looked up is based off a value that will only show up on the selected index row...

Hi all, Thanks for reading my post. I had a very rudimentary question but can't seem to get me head around it. I have 2 lists, as seen below: FYI on a 2 X 6 matrix starting on cell A! A B 1|Student Name |Age| 2|Student 1 |018| 3|Student 2 |020|...