vlook up

I have a set of data (see picture attached), where different projects have several dates, even within same month (A3:B16). My goal is to build a ''calendar'' that will show Projects and their first date that will fit within the selected month. E.g. in the picture: I want to see the projects...

I'm trying to do a vlookup (or an index/match if those functions are better suited), to find values based on the matching date, as well as 2 headers on a single column, and then I need to sum the returned values. The challenge I'm running into, is that I need to pull the data that matches the...

Hello, I need help, if I have a case to do a vlookup with 2 categories so that if criteria one is not found then it will be searched for with criteria two. I want to find "price" with the first criteria "code", if can't find it then look for the second criterion "product". Please help, what is...

I have a computer generated list of skills for 60 candidates. The goal is to build a table that tallys the skills across all candidates to determine which skills are most frequest there most important. However the list of skills I have for each candidate is messy. For example, Candidate A...

Hi, I am currently working with Google sheets on my phone so restricted with how to show what I am after. I want L4 to reference Q3 and return a value from the range FE25:FF63 Basically the values in column FF increase but there’s no pattern to the increase in the respective FE row is the...

Hi all.. I need to pull in some data across sheets and having a hard time.. Essentially I'm working on two data sheets. For sheet 2, I want to pull in a number from sheet 1 if it meets 2 criteria, A) if the name matches say cell A1 and B) if the colour matches O1, then for it to look into...

Hi, this is the vlookup I currently have (that works) VLOOKUP(F2,'\\documents\August\[File Name 30.08.22.xlsm]Sheet 1'!$F:$Z,21,0) The issue is that everyday I have to reset the formula with the prior working day so that it's pulling through the latest comments. I'm trying to create a static...

I have been using an index match to pull data from a query to one of my spreadsheets. At first I was just having my query pull one day at a time so it was pretty simple. Now, I am having the query pull data from March till present and I need to index match my spreadsheet with multiple different...

code excerpt: Dim lc As Long lc = Cells(1, columns.Count).End(xlToLeft).column Dim cel2 As Range Dim srchrng As Range Set srchrng = Range(Cells(1, 39), Cells(1, lc)) For Each cel2 In srchrng cel2.Offset(1, 0) = Application.WorksheetFunction.VLookup(ActiveSheet.Name &...

Hi, Trying to do something that is WAY too advanced for myself. will try to explain the context of what I need to achieve etc etc. I have an excel with financial product names in lets say column A I then have current value of said financial product in Column C I then have the percentage that...

Hi I apologise in advance if this is not clear but I’ve tried to refine my thoughts. In this link is a modified (smaller) version of a file I’m working on - Help Please.xlsx I have a page called explanation trying to highlight what I am wanting to achieve but I will go over it here as well...

Hi All, I need to vlookup on a filtered range using VBA. I have gone through different threads posted on same topic, however they can't actually answer my question. Basically the sheet where I need to perform the lookup, will be received via User input. My code goes as follows : Option...

By the title, you've guessed I'm struggling to find the right path for what seems pretty basic. But trying to adopt the formulas from the posts and the videos leads me to #REF! despair! The attached Workbook has been reduced to the important parts: A worksheet called "Pine Lakes Front" and...

Hi team, Can you please help me find a solution to the below issue? I tried Vlookup, but it is really time-consuming. I have two sheets. One with the contact details and one with the product details. I want them to map it based on the account data. Sheet 1: Sheet 2 Result required ...

Hi. Previously, I have posted this question How to split the name and display the status of task/project for each name?. Usually, each staff has their own task for the similar project. I tried to add additional column, which is Task and the output only recognize the first and second name of...

Hey everyone, I have a sheet with 500 values that I need to vlookup against 50k products. Normally that woudnt be a problem with vlookup but in this dataset one value can have multiple results and vlookup only takes the first one. So my question is is there an easy way to get multiple vlookup...

Hi All, I have a knockout tournament for 16 players. When you lose a match you are out the first round just puts the players in the firstbox =CONCATENATE(B19, " & ", B20) The second box (semi final) has the statement =IFERROR(VLOOKUP(TRUE,A2:B3,2,FALSE),""). Then I have a final box with the...

Hello, I have a spreadsheet that changes dynamically using the offset function. I want to be able to subtract in 1 column. I want to subtract the very last value in the last row by the first value. For example: In the image, please ignore column B. "Change in NFP", column C, is the column in...

Hi All! I work for a university and have done an audit on subjects and the specific skills required for that subject. I have a table that shows the subject's code, the skill required and when during the term their subject should receive support (before an assessment item that requires that...

Hi Excel Gurus, I've been working on this problem for days and tried numerous different formula to no avail, any help is appreciated! Problem: I have a list of 250,000 emails that needs to have all emails associated with lawyers removed (ex. info@lawofficexyz.com). Attempted Solutions: In...