-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
match - if
-
F
Making a cell red if the first cell and the second cell's formula result don't match
I am currently working on a spread sheet for my work place where I need to check whether the database's information is accurate compared to the hard copies. I wanted to make it easy to check through the 700 rows of information. I have managed to get an excel document of the database...- falconm11
- Thread
- color a cell equal value decimal places match - if tax
- Replies: 4
- Forum: Excel Questions
-
S
Returning Debtors Balance if Student is youngest in family
I would like to only return the Family Debtor Balance against the youngest student, so that the total database = my Debtors Control account. For Example: <tbody> FAMILY CODE Class STUD ORDER BALANCE STEFJ P1 3 1000 DOCHM P1 1 2000 WEARA S2 1 1000 MCARS S3 2 1500 LAIRD P2 1 1800...- Stef56
- Thread
- if statement index match lookup function match - if
- Replies: 7
- Forum: Excel Questions
-
B
creating a hyperlink in a cell after a different input is added in that cell
i'm curious if this is possible: first, lets say at the bottom of my worksheet i have cells A100-A110 each containing the text of either "V1", "V2"....."V10", now say if i enter into a blank cell the text "V1", is there a way to create a formula where it turns that cell into a hyperlink to...- banneduser123
- Thread
- formula as cell reference hyperlink cells hyperlink function hyperlinks match - if
- Replies: 0
- Forum: Excel Questions
-
N
Comparing columns & returning values
Im going crazy trying to figure this out, help please! I have data that looks like this: _A__|_B__|_C__|_D__ 123…………….234….$12 234 …………..236….$56 236 …………..123….$11 654 …………..764….$87 001 …………..654….$98 002………………………….. 764 …$87…………………. 670………………………….. Columns A & C are sku's. Column D is the...- nickkoehler
- Thread
- if statement match - if match columns vlookup
- Replies: 1
- Forum: Excel Questions
-
D
Match If with MAX, Non-Number Matches, Return other column values
Thanks for your help. I have read through all of the various Match If posts and still having trouble. The goal is to find the max value within a column (spend on a product), restricted by another parameter (industry), and then subsequently use those restrictions to return a value in another...- Docendo
- Thread
- array index index & match match - if max if
- Replies: 0
- Forum: Excel Questions
-
M
Need Formula for if 2 cells state a SPECIFIC value to return a 1.
I have two columns that return the phrases of "Late" and "Not Late" in Column M & N (based on two different formulas). I am looking for a formula that will read the text and return a value of "1" ONLY if it both cells in M & N states "Late". Anyone know of anything? Basically what I want the...- misspaulaj
- Thread
- match - if
- Replies: 5
- Forum: Excel Questions
-
M
Find date/time that is between dates/times in another dataset
So I have two sets of data that I need to match up. Set 1: Column A has "Vehicles" like 29, 21, 20, etc. Column B has "Date/time" of when that vehicle last sent data. Set 2: Column D has the "Arrival Date/Time" of when the vehicle entered a location. Column E has the "Departure Date/Time" of...- MagiCarty
- Thread
- between dates date & time match match - if
- Replies: 3
- Forum: Excel Questions
-
C
help needed - match if
Please help!!! I am currently working with this formula, =IF(ISNA(MATCH(A2,Database!B:B,0)),"No match","") - its working well, pretty much it tells me "No match" when it can't find a value on the second column. BUT now I also need for it to be able to discriminate between values. I want...- crisb
- Thread
- excel match - if
- Replies: 1
- Forum: Excel Questions
