if/then statements

Hello. I am new to using Power Query and have gotten stuck on something and am looking for some help. In a data set I would like to categorize the values in one of the fields using some kind of If/Then/And/Or logic. I can figure out the logic if I was using an Excel formula, but I am...

Hello Everyone! I hope this makes sense... I have a table on [Sheet25], Range F5:F97 & G5:G97 What I want is my host cell ("K8") on [Sheet26] to pull a value (in my case a link) from the aforementioned table based on what value is entered on [Sheet13] ("G11") example: if [Sheet13] ("G11") =...

I have a macro that I want it to look at a table and if there is data in the table then I want it to complete a VLookup but if there is no data in the table then I want it to end the if statement and move to the next statement (there are 3 tables in total the macro moves through). It is always...

I am trying to auto-populate cells using IF/Then Statements (I think) The following is a description of the sample table below: - Hours (Number of Hours Worked) - Role Name - Role Code (LSEA, SEA1, SEA2, SEA3, Tools, PM, GOV) Question: How do I link the hours for a specific Role name to the...

I am creating a database for a coworker. He has various football helmets that are labeled 1-363. Each helmet has a size and we need a cell to auto populate the size when the user enters the helmet number. The problem is that the sizes of the helmets is not consistent to the helmet number...

Hey there guys. I'm trying to revamp one of my macros so that it will pull up a new userform based on information input into the first userform. What I can't figure out is how to get the system to call the second userform once it's figured out the if/then statement. The code I'm trying to use is...

I have a spreadsheet in which column D always contains substrings of "women's", "women" or "womens" for women's clothing, or "men's", "men" or "mens" for men's clothing. Based on whether the substring is women's or men's, users enter a whole number value in column I, <= 20000 for women's and <=...

Hi, How do I set an if/then statement for a result between two values? I have a value in A1 that will change periodically and I want the cells beneath it to reflect that change (this is part of a greater summation scheme that's already been set up): A1= 2 A2: if (x<1, A1, 0), this one is easy...

Hello, I have a particular set of data: AA BB AB CC CA CD DA FA FD FC I want to create an if/then statement to delete all values that contain either an "A" or a "D" for purposes of eliminating irrelevant data. What would my statement look like? Thanks in advance!

Hello, I have a problem that has stumped me. I would be eternally grateful if someone could help me. Problem: “total_members” value does not include people with “Name” of “AAA”. For example, in expedition #2, you can see that total members is listed as 4, when it should say 5. However, not all...

I have a Range of Cells that I would like to transfer to PowerPoint using VBA Macro. The problem is that some of the cells are emty at times and I want to leave them out of the final range that is moved to PPT. I'm thinking that I have to select the largest possible range and then do some...

Hi all, I am currently working on a project to automate a report that is run monthly. In order to do this I have made it dynamic so that it can reference files based on the run date etc and it is working quite well. What has got me a bit stumped is what I think should be a straightforward...

Hello, I am trying to align a column of data with a neighboring column so that the data is in one continuous row. For instance, this is how the data looks now: Bill (e.g. A2 5 (neighboring column, one space down. e.g. B3) Chrissy 8 (neighboring column, one space...

I need to write an if/then statement so if multiple words are found in a cell, it needs to indicate it. For example, if "Home", "Homeowner", or "Condo" is found in column A, I would like "HOME" to be inserted in column B. Can you help me write the formula? <TABLE style="WIDTH: 299pt...

I'm creating a type of checklist in Excel where I have the general milestone/task listed in a column with all of the individual steps to complete the task listed under it. What I want is after the completion date of every individual step has been entered in Column E, for today's date [TODAY()]...