I am trying to create a Vlookup to pull in data from various sheets. The formula below works for my purposes however I would like to have a variable table array as at present when copy the data to the next column for a new week number I have to manually type the week number for every single row...
Okay so I think I've exhausted my googling/foruming options trying to figure this out. I've found a ton of things that are very close to this problem but not quite the same. I'm pretty certain I'm going to need an array formula. Essentially I have data that looks like this:
<tbody>
Date
Numb...
I need help creating a macro that will populate each row in column "C" with data from column "B", but with the following differences:
It should substitute the error codes with the lookup values in the error key "$E$3:$G$50".
It should ignore Error Codes (AS01), (AS16), and (AS17).
All other...
Hi,
I'm trying to set up a series of HLookups for a template we use to handle our quotations, acknowledgements, invoices etc at work.
I've created the whole thing and have been asked to simplify how we search our reporting pricing.
I want to create product codes for how long each contract is...
I have a table that looks like this:
Need Col D values that have ";" present to be parsed out to create and new worksheet with the results looking like the output below.
I've looked & tried but is beyond my level at this time. Any & all help is greatly appreciated!
:banghead:
Excel...
Hi,
Here is what I have so far.
I have a list of 100 students from grade 7 to 10 which I have ranked based on their attendance %.
What I am wanting is a list of top 15 attenders based on what grade they are in. lets say grade 7
My thoughts would be to vlookup small 1 through to 15 (from...
All,
I am completely stumped. I would rather not use VBA or Macros for this problem, but understand if that will make things a lot easier. This may be a simple formula, but I have been struggling to figure this one out. Here's the information.
I am trying to auto create a table based on the...
Hi All,
I am having some trouble trying to create a query that will return a default value if the date being looked up falls between any of the start and end times in another table.
The date being looked up is in table1 and start and end dates are in table2. I need for the value in table 1 to...
I am attempting to match data (state and year) in two tables that have the same h row and v column headers by using 2 drop list
<tbody>
State
Year
Population
Cases
Drop List
Drop List
Result From Table 1
Result From Table 2
</tbody>
Both tables would look similar to the following:
Table 1...
I am attempting to match data (state and year) in two tables that have the same h row and v column headers by using 2 drop list
State
Year
Population
Cases
Drop List
Drop List
Result From Table 1
Result From Table 2
Both tables would look similar to the following:
Table 1 (Population)...
I'm building a tracker that's looking at recurring expenses from four different locations. Because I added a table to excel, it won't let me share the book, so I want this one table or range to populate/pull the information as its updated on the other four products. This table needs to expand as...
Hi there!
I'm working in a spreadsheet that has a sheet for months Jan - Aug with a list of names in each, I then have a separate sheet that has a list of names including ones that aren't found in months Jan - Aug.
What i'm trying to do is search in months Jan - Aug for the names that appear...
Hello all. First off thank you so much for all your help. Mr. Excel and your forums has helped me out so much. I am still in the very beginnings of understanding VBA so please forgive my ignorance on certain topics.
This is what I am trying to do.
I am trying to set a cell to...
Hi Excel people,
I am in need of the formula which will allow me to calculate the amount to be charged once it falls between a range. Each separate range gets charged at a different rate.
<tbody>
Investment
$173,543
$2,620.76
Scale
Fee Scale
Investment Amount
Fee $...
Good morning,
I am trying to invent a formula, that in a single calculation (withoutadding two calculations) will allow me to count all "currentemployees" from "employees" table. I have a data table"Employees" with a column "Work To" which is:
usually empty (for current employees not on...
Is it possible to have the table array in a vlookup formula be a variable driven by another cell in the workbook?
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
I have the following formula where the table array is a named range "IJSA_PL_Lookup_Array". This is a range of...
I have two tables and would like to look at values assigned to categories in one table and in another table, only populate the largest value to the same category. For example:
Table1 has the following categories:
1 2
A Apple
B Boy
C Cat
D Dog
Table2 has the same categories with...
Hi All,
I'm looking to do a two-variable what-if sensitivity analysis, however, instead of just doing a simple sensitivity to a row cell and a column cell, I would like to shift an entire array as the column and row variables (see below).
The reason being that I have multiple "consumer...
imgur: the simple image sharer
Greetings everyone!
So I have been trying to explore this for far too long now, but now I gave up. I have this VLOOKUP formula which is supposed to take data from 'Table1' and show it to 'Table2', it shows the correct result on the...
I have a report that looks up the top 3 errors in a table by %. Rarely are the %'s the same but sometimes they calculate out to be.
Right now I'm using a Vlookup to return my results, but if (for example) there are 2 results that = 50%, both of my return values will be for sentence1 and not...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.