I am trying to come up with a formula that will review two lists (A2:A6 and D2:D6), and if any cells in the lists match, then return the value of that match from Column B. There would not be multiple answers to this (Option 1 and Option 2 would not be listed in D2:D6). Example below...
Trying to get this to work but no matter how I try it I either get mismatch or syntax error. Hopefully it's an easy fix thanks in advance!
Dim X As Range
Set X = Range("D1:D13")
If X = "Passed" Then
Rows("D1:D13").EntireRow.Hidden = True...
Hi! I'm new to VBA and need help. I have a column on one worksheet titled "Profit" that has various numbers listed in column C that correspond with the accounts in column A. On another worksheet titled "Total" I have a cell that I need to filter by. I'm trying to come up with an "If" statement...
Hello Excel God's and Goddesses - Here again asking for some help, this Time with Conditional formatting
Cell A1 contains a dollar amount and cell B1 contains a % number from 0-100% What I'm looking to do is apply conditional formatting to cell A1 based on the value of cell B1 as follows
I am trying to find the best way to get the correct answer from the below table. Basically the answer will depend on 2 things:
The percentage range in A & B
The value the product is between.
I have two cells in another sheet, one states the percentage, and the other the amount. What I...
I am new to Excel, so this may be a basic question. I have two Columns:
I would like to create a formula in one cell (E2) such that if I place an "x" (or a number perhaps) in a cell in column B, the corresponding value in Column A will appear in cell E2. For...
I’m looking to create a formula that will look at two separate columns [Status] and [Quarter] and select (for example) HP in column F and Q1 in column. Then add all those particular numbers located in the G column and add them. Example would be an outcome of all numbers added would have both...
I have a simple if statement =IF(G5>1,G6:G11,0). The false portion works, but the true portion generates a #Valule, which doesnt make since. The formula appears to be straight forward. Is there something I need to turn on within 2010 or is there some syntax I am missing? Thanks for any...
I need some help here. I've looked everywhere but can't seem to find it.
I have a due date in B2 and =TODAY() in A1. I need a formula that says if B2 is <= today then it will say "late" but if B2>today then it will say ""
please help. These formulas confuse me big time.
I need some help with a formula in Google Docs.
It's an inventory spreadsheet, so I have a column for 'need', 'got ' and' to order '. I need to subtract need from got and have that number to to the order column. If that number is negative due to having more than I need, I need the answer to be...
I know this should be easy... TIA...
I'm in cell c2… if cell c3 contains just any two characters only (a-z or 0-9) then make this cell equal "." (just a period [or any char I choose]), otherwise just leave cell c2 blank.
I am a relative Excel novice, but have thoroughly explored MS Excel Help and other online help forums for an answer to my question, and at this point, I am wondering if what I want to do is even possible? Please help!
I want the formula to return a single sum for multiple conditions (two, to be...
Hi everybody im new here and I already have a question for you guys
So I gotta find mif a cell is between a range of numbers
Something like IF a1>=100 but <400 then 50, if a1<400 but <600 then 100, if a1 <600 but >800 then 150
Hope you guys understand I just need that Excel give me a number...