## Vlookup between multiple criteria and then yes or no match

I want to look up prices for styles based on which store they are in (field or house). The prices are different for both. For example, I want style 2012 price …

I want to look up prices for styles based on which store they are in (field or house). The prices are different for both. For example, I want style 2012 price …

How the increase decimal operation is performed in Excel and how they done it? Case 1 : I enter a number in a cell whose number of digit is less …

I need to know when various symbols can appear in Excel (Conditional Formatting) Formulas, and when a letter character followed by a number character can …

Hi, I am trying to use a wildcard in a formula but it is producing a result of ‘false’ instead of the answer. If i remove the wildcard the formula …

I am trying to see if Excel can do this: I have a budget spreadsheet with items I have budgeted for with 4 columns that represent each week of a month. In …

Hello, I’m helping my dad manage his finances, and I’m trying to use Excel to help him do that. Here’s what I need: The image below shows a …

I have a list of postcodes in one column and would like to create a formula which will identify the town that the postcode belongs to. Is this possible? …

KAUN BANEGA LAKHPATI NAME LIFE LINES USED ANSWER AWARD 50/50 TELEPHONE AUDIENCE RAMESH T F T DINESH F F F UMESH …

I am looking for how I would find the difference between two sets of numbers with one common factor. Any help is greatly appreciated!! By: LaTrisha

if cell A1 contain some name cell B1 contain values of formula and if b1 becames 0 than it should automatically became red till this i have use command …

Hey guys! I would like to know how could I assign values to text, or better said, for my “products”. I’m fashioning a drink calculator …

Hi, I’m looking for a solution to a problem. I have an excel sheet that upon using a macro it adds a whole new row with a ” # ” in a …

Hi there! Currently working on something that adds hours up over 4 weeks to sum the total hours worked in a month. However, I cannot allow the spreadsheet to …

Hello, I am looking to find a way to divide certain value based on the drop down choices in excel. What I am trying to do is to make a way to …

In our computer system, we have different codes for everyday tasks. Problem is the codes are different for each division we have. For Example: …

I will do my best to explain what I’m looking for – I hope it makes sense! I have included a bit of my worksheet so you can hopefully understand …

Hi, I have a set of field to compare in 2 different spreadsheet out of which any match will then check and return for a specific value in another …

Hi All Im wondering if somebody can help I am using the below formula to calculate hours it all works apart from if a cell is empty for …

Hi All, I’d appreciate your help on the below: Outline: – 3 people (Amy, Harry, Sophie) …

How do I extract the date if the given data are: 1) Week ending date 2) Days of the week (for which the exact date falls into) See example below: …

So we are exporting data from FileMaker Pro. We have a column labeled as location and it will say something along the lines of: Tank II Rack 3 Slot 23. (There …

Please enter the excel formula if you need the cell to show “0” if 3 plus 4 equals and “1” 3 plus 4 is either greater than or less than …

Hello I want to formulate this [(n=0)∑(n=Ϻ-1) 1/n! (λ/μ)^n ] I’ve been browsing the net for half day and can’t find it. It …

Hello, Don’t really know how to name this problem properly. Just made it more in a general sense rather than a specific one. Here’s the problem, …

I am wanting to create an automated General Ledger and Journal Entries. The way I am wanting to set this is up is having a list set up that a user can choose …

Hi, I have an issue. Lets say I have 4 numbers (10, 50, 100, 250) and I want excel to give me the best combination of those numbers that will get me as …

Aoa, i am Uzma Razzaq from Islamabad Pakistan. i need a formula for excel sheet. As i have record of fee of school students. Condition: If more than one child …

Hello, I am new to VBA formulas in excel. I have a workbook with multiple sheets which needs to be copied(only values) in a master sheet in the same workbook. …

I am using Excel 2016. I need to figure how to get the cell to calculate the total by adding specific amounts which are based on an index. For the …

Need to consolidate or look up which client deposited funds to our account. On our BANK DATA we see the account number or a reference from whom the transfer is …

I am needing help with the following I have spreadsheet that states employees hire date and formula to calculate that date to current date which auto generates …

Hi, I want to make the information in some columns (but not all) displaying in rows, please see below an example. This is what I have: …

Hi, As written in the title, I want to copy past (similar to dragging down the formula) from a cell above if another specific cell contains a specific …

Hi everyone, I was wondering if someone could push me in the right direction regarding how to build a formula. I am looking for something to display …

I want to compare row and column values. My formula is =IF(A2=B1,1,0) . Next below cell formula would be =IF(A3=B1,1,0) and so on. Meaning compare the value of …

Hello, I am working in a retail store and need to audit my inventory. I need to scan barcode tag which in return gives item code size and color of …

Good afternoon. I have a complex formula that I need to build and don’t know where to start with it. i have built an automated front sheet that looks …

Hi, Firstly sorry if my Excel lingo is a bit off as I’m self taught in Excel. Okay so my problem is simple, say if I had the letters a,b,c,d,e in the …

Hi guys, there’s one thing that I wanted to do but couldn’t find any similar case after hours of googling. Here’s the case I have a list of …

Hi, I’m trying to find out if I can input a file name such as “file name_123456_2018_NI” into one cell and have just what is before the first …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.