vlookup & if

Hi have a list of users and a list of tickets that have been raised in the last 12 months. I am trying to put together a formula that looks up the user in the list of tickets to check if they have had a ticket raised for them. The last 12 months doesnt need to be in the formula as my list of...

Hey, how do i make it so that my Vlookup checks a cell for the text "Stål Ok" and if the cell text is something else then "Stål Ok" it takes that text and makes it red (It is normally a date. Example: "25.sep") Would be super helpful if someone could help me with this. Thanks! EDIT: So...

I want to lookup the purchase records for a list of items having one quantity each from a data having following fields column a,b,c,d,e as follows item code, quantity, date, invoice number, discount in such a way that it uses the lifo principle but based on the quantity of purchase records for...

Hello All, I have an existing IF Statement (shown below) in Col P of the "Book Average Balance" sheet which has many conditions that will pull (sign reversed) data from Col K if all are met. That old formula does work, however it is not dynamic to update. If there are new accounts that are...

Hi Gurus, Any thoughts on what would be the right sumif lookup formula for below scenario? Sheet 1 - I have a long list of Data. Simple example below: Name Change Sam 250 Mike 300 Sam -500 Mike -150 Sam -50 Mike -25 Sheet 2 - I'm having a hard time doing it in pivot so just...

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

Ok, I have figured out the Countif, and basic vlookup concept. However, what I can't figure out is how to search the text data in one worksheet (Part numbers) and populate a shortlist of those part numbers based on their status (Open/close) into another worksheet. It seems to me, that vlookup...

Hi all, Apologies if this has been asked before but i cannot find an answer to my question on here or on google. I have the below formula which is a standard vlookup which returns a certain value found for A, B, C etc =IF(VLOOKUP($A7,'CHRISTMAS GIFT...

Hi Experts, Could you please help me complete this formula? I am looking up a value in one sheet, and if it is found then display it, if it is not found, then lookup in the second sheet, if it is found display it, and then so on and so forth. The example I have so far is...

I am having an issue with finding the correct syntax to utilize the vlookup where two criteria are met if the first vlookup returns no data. so I was thinking something like find host on datatableA, - if there is an address value (not blank), display it; if not, then look for the host {still on...

Hi, I have a scenario where I have 3 sheets/tabs with 3 different sets of data in them. So lets call the tabs 1stWash, 2ndWash, 3rdWash. In another tab lets call it Results I have to return the Postcode from the 1stWash (say column 47 if a cell value = 1) If however the cell value = 2 then I...

I’m trying to do something that I thought would be relatively simple but turns out to be more complicated than I thought and I am stuck. I have two sheets with data and need to do the following: Look up an email address located in sheet one (column E), find the email in the second sheet (column...

Hi guys, so here is what I'm trying to do. I have a column of 10 digit position numbers. I have it formatted to text because some numbers start with 0. What I need to happen is to determine if individuals are "double slotted" against the same position number. I was attempting to use VLookup to...

Not sure how to properly explain this. I have a table of food items only some of which will be ordered. In a separate tab I want to list out only those items that need to be ordered with the order quantity. For example here is a data set: <colgroup><col><col><col><col><col...

Having trouble figuring this out, and I'm new to this. In fact, this is my first foray into the world of Excel. =IFERROR(VLOOKUP(A2,$E:$F,2,FALSE),A2) Using this formula in column B, I want to return the data from column F based on the info entered in A. Additionally, if A returns an error...

Hi guys, from looking up formulas online I made this, where am I going wrong? it just returns an error. =IF((d5)={<90%,<95%,<100%,>105%,<110%,<115%,<120%,<125%,<130%,<135%,>135%)},{C23,C24,C25,C26,C27,C28,C29,C30,C31,C32,C33})) It may be something so simple but I can't for the life of me...

i need to copy values from a table when 2 other conditions are met. Table 1 <tbody> ID COUNTRY TYPE Details AA AZ READ This is used for reading in AZ AB UK Write This is used for writing in UK CD US EDIT This is used for editing in US AA AZ Write This is used for writing in AZ...

i have a dropdown in A1 which is 2 companies, i have data for these companies on 2 separate worksheets. what i would like is, if A1 =company 1 i could have a vlookup for that sheet in tabs A4:D4, but if A1 = company 2 a vlookup to that sheet would be needed for the same range. i have looked at...

I have the below formulae on a tab called Tracking Sheet. It current has 3 levels but I need to push it out to 15 levels as I have separate choices. =IF(H1="Unit 11",VLOOKUP(A1,Unit11,1,FALSE),IF(H1="Unit 13",VLOOKUP(A1,Unit13,1,FALSE),IF(H1="Unit 14",VLOOKUP(A1,Unit14,1,FALSE),"No"))) H1...

Hi guys, I really need your help with my project, because i am stuck.. first, here is the link to my example file: https://www.dropbox.com/s/9vkh8y5w30le6r2/Map1.xlsx?dl=0 What i want to accomplish is. (just write it down what is logical for me tho:smile:) 1st issue: with...