Hey, newbie here ☺️
I have a sheet where I want to return the job value (Column H) to a certain column depending on it's expected order date (Column T)
So I have this for my formula... =IF(AND(T8>$W$2,T8<$W$1),H8,"")
However, if the expected order date is on the 1st or last day of the month...
Hello. I have workbook that lists badge numbers in column A. Hours in column H. I want to be able to add up all the hours by badge id. The problem is the a badge number can appear multiple times. So a regular Vlookup will not work. I have also tried a sumif formula. This adds them up however, it...
Hi! I am new to VBA & Macros and didn't think I would get stuck on Vlookup, but here I am. I cannot figure out why it is not pulling in my date field from sheet 2. I have tried numerous things to try to make it work, but now seems like I am running in circles. Maybe a macro would be the better...
I have a two sheet workspace. Sheet 1 is called Data and sheet 2 is Print Dates.
In Sheet 1 I have in multiple columns three sites. Site 1, 2 and 3. Site reference is found in row 3.
Columns A4:A80 are dates for Site 1, Columns C4:C80 are dates for Site 2 and Columns E4:E80 are...
Kindly let me know how to integrate the VLOOKUP function with MAX in order to format data of Table 1 for the given query ids as in Table 2. Moreover, I would appreciate it if you could help with the formula to populate the Max identity value in the neighboring cell:
Greetings to all.
First of all, I am new to this forum and need the help of your excel knowledge.
I have a workbook with the Sheets: A, B, C. On the B sheet I am collecting data from sheet A, and trying to collect other data from sheet C. Since the VLOOKUP wont collect negative col_index_num...
Using VBA to find prices then fill prices to a different worksheet.
I created a code below but it won't run it skips over the code and nothing happens.
Dim JCMLastRow As Long, x As Long
Dim DataRng As Range
Dim PartsList As Worksheet...
This might be a simple problem and I've been scouring the internet, but I haven't quite found the solution yet. I have two sheets, "Master Parts List" is my master list with column B having the line number. What I want to do is manually enter the line number into column B in "Template" and have...
Ok, I can't seem to find the answer to this anywhere.
I have a table of data, specifically from google search console
Let's say it looks like this:
I build a simple spreadsheet to keep track of the job numbers I work on through the day. In order to get paid, these job numbers have a corresponding SR number that I am pulling from a table. Some jobs may not have a SR number, so those need to be requested. I made a simple formula that should...
Please note that I made an earlier thread and am now continuing with the same sheets as before, but also including a new file (file 3). The old thread is here: Excel vlookup problems
I currently have three files, file (1):
And file 3:
Currently, file 3 has the...
I am relatively new to Excel and have little experience with functions, especially across different excel files.
I currently have two excel-files, where one looks like this (file 1):
And the other one looks like this (file 2):
Currently, what I would like is for file 1 to...
I have a set of sheets which contain data which I pull into my VBA code with vlookups. The input data is collected into a table of data 10 columns wide, the key field is always an integer between 1 and 3000 but depending on the data entered by the users I might have 5 entries or 3000. The...
I have a table of people with a date, start time and end time, as well as task performed by that person. The problem is that most cells in the colum of end time are blank and I would like to take the start time of that person on the same day for another task (the person changed...
I have created an example version of the spreadsheet I am attempting to create.
Each months sheet looks like what I have posted below. I am looking to use one of these sheets each month. I would then like an analysis tab where I can look at;
-Overall Average of "Test Scores" - (I can and have...
I would like to find a way to look up what the discount was on an item within a table.
Sku 1100748, what was the price back in November 1/19
Below shows it has been marked down 3 times. the price from Aug 1/19 on was $20 (disc_amt).
How can I tell vloookup to look at the price that was...
Let me try and explain what I need with a simplified example:
I have a table (H3:I5) that gives me the value for each item (I have dozens of items in the reality).
I need, for each month (in B9, C9, D9), to know the sum of the value of each item for the particular month... but only...
Hello Wizards! In advance thank you so much for any help. I am self taught and have gotten along "ok" (I spend hours to complete what you all would deem simple) but my current need is too complex for me to think thru. Here goes:
I am attempting to create a lookup from a cover sheet to another...
I have been looking everywhere for a solution but have had no luck so far, hopefully one of you can help me with this.
I want to compare the text in E2 with a list of text in I, J, and K, and
if the VLOOKUP is succesful in I, the formula should input the text "Nybyg",
if unsuccesful it should...
I have a spreadsheet with more than 200 columns, and each column has different values with different sizes.
I'm trying to find some sets of values and here are my questions;
1) How can I find the most frequently used set with size 3? (eg. CD8, CD3, CD4 or CD8, FoxP3, PanCK)
2) After I...