if & vlookup

I have a column of names and another to show if they have had work done on their computer. If work has been completed there will be some text in the cell, if not it will be empty. I would like a list that shows the systems that are outstanding and when I put an x in the cell next to the...

I have the following formula =LOOKUP(DATEDIF(AE4,NOW(),"Y"),{0,4;1,4;2,4;3,6;15,8}) to determine how much leave someone earns based off the years they have worked and when the person is only earning 6 hours, i need to add 4 hours to the last week of the year. How can I do this? Do I need to...

Hi Guys, I have a question about excel. i would like to create a function with this criteria : when the wbs is GWV1P100275-01 until GWV1P100275-09 i would like to take in "I" cell the value GWV1P100275 , when the wbs is GWV1P100275-01-001 until GWV1P100275-01-009 i would like to take in "I'...

I am trying to lookup only "DELIVERED" items and have it look up based on tracking number, then return the date it was delivered from Sheet 2 Col L to Sheet 1 Col J, but ONLY if Sheet 1, Col C status says DELIVERED, otherwise leave blank not some error code like Ref# or something else. Also, how...

Hello, I have created a master inventory excel sheet to keep track of all my inventory. It consists of 4 tabs; Lists, Shipping Log, Receiving Log, and Inventory On my Inventory sheet, I am wanting to add any merchandise from the receiving log to the previous inventory on the 'Lists' tab. At...

I have a formula =IF($A2="","",VLOOKUP($C2,$R:$S2)) The problem is, it does not recognize 2313A and returns a lookup of 123 instead And 456 returns a lookup of 2313A Why is it doing this? Spent days looking at this and can not figure out why. The lookup list is something like this : Columns R...

Dear All, Appreciate your assistance to my inquiry below. I wanted to extract the highlighted decimal number (put in Column B) from the text string cell (Column A) as below. Anyone can assist on the formula? Source - text string cell in Column A 1/11/21 960 C P GL 71,959.26 71,959.26 CR...

Hi guys I was wondering if there was a way to do a Vlookup with an IF, AND, perhaps even an ISBLANK statement and what that formula would look like for the following scenario. I am trying to create a worksheet that will allow me to type in a restaurant ID and it tell me if It is closed on...

Hi I am working on a spreadsheet that will calculate what hour a store should close based upon it's last hour or sales. The logic works like this: a) If a store has greater than $100 of sales in it's last hour, close one hour later. b) If a store has less than $50 of sales in it's last hour...

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

Hi All, Need help, I am struggling to find the solution. Below is my details, A B C D E F G H I J 1 Name Date 1 2 3 4 5 6 7 8 2 Day Fri Sat Sun Mon Tue Wed Thu Fri 3 Mr. A B B B A A O B A 4 Mr. B A A O B B L O B 5 Mr. C L O L L L B A A...

Hi, its me again, I have another problem, the thing is that I want to find the name of multiple Stores, I have the store id and I have the Stores Database in another worksheet, the the thing that I want is to run a macro that search me automatically every code that i put in a extensive...

Hi everyone, Perhaps not drinking water is affecting me or this is just a formula I've not learned yet! I'm trying to begin my journey into learning PowerBI and with that I'm reworking an existing spreadsheet to be PowerBi uploading friendly. I'll try to explain this simply: I have different...

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

Hi, I am working on a formula for which I think I might need a macros. I have a vlookup formula that looks up a value in column D, and matches the returned value (column E) with column B. If there is a match, the value in column C is returned. However, the vlookup needs to be applied to several...

Hi all, Having trouble on these few methods. I'm new to excel so guy i need your help. I have a list of different product items example: Marigold Orange Juice Marigold Apple Juice Sunkist Orange Juice Sunkist Apple Juice Tropicana Orange Juice Tropicana Apple Juice All of these i have...