if cell contains x then

Hello, We have a simple break list at work. I spent a lot of time making a better one, but the manager said it's too complicated. I want to improve the one we have now at least a little. (screenshot attached) In this break list, when you click on a cell under the "status" column - you have 4...

Hi all, I got a worksheet with many combo boxes they're linked to a cell and what my idea is to provide a prompt if one of the cell within the range contain text which is not allowed. So i got combo box S1-S29 The selection user can click within that combo box is : Kies,1,2,3,4,5 So I tried the...

Hello, I'm working in EXCEL 2016 and trying to create a formula where If cell contains certain text, then return value. I have the text in column B and would like to create a formula that returns the values in column A. Any help is greatly appreciated ;-) <tbody> COLUMN A COLUMN B 1 PAK...

Currently I am working with my data collection on my master thesis and I am trying to figure out which formula to use in order to gather together the information from two different sheets on Excel. For example Sheet 1: I have stock with the code nr of "8135" and daily stock return for this...

Product A, B & C are available in Material 1, 2 & 3 (9 products, 9 different prices). Problem I'm trying to solve is to figure out how to apply a % discount, then a flat $ discount (if applicable), based on a selection, only if the cell(s) are referenced. Example is col A has Prod A (A2), Prod B...

I'm have 2 sheets of data, I used VLOOKUP to compare variances from each sheet, but i need a macro or IF function to past the data next to my value. I'd like to solve for the following: If cell A1's value (in sheet 1) is also found in sheet 2, paste that data in adjacent columns from sheet 1...