-
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.
oscar
-
O
Multiplying columns if criteria is met
Hello, Probably simple question here, but I am struggling with SUMIFS and SUMPRODUCT so I am reaching out for help. I have 3 columns: Two have values that need to be multiplied if a condition in the 3rd column is met. For simplicity, here is an example <tbody> Value 1 Value 2 Criteria 2 10...- oscarj
- Thread
- columns criteria met oscar result
- Replies: 9
- Forum: Excel Questions
-
M
VLookup formula and #N/A
I have a VLOOKUP formula that works on the first cell it is used. However, it fails on all subsequent rows. This is my formula...in cell V2 where it works. Then when copied to V3 it fails. =VLOOKUP(W2,'Engineering'!$C$2:$J$375,8,FALSE) This is the formula I have in V3... =VLOOKUP(W3,'OSP...- mad3
- Thread
- 909.748.6650 martinez oscar south todd
- Replies: 8
- Forum: Excel Questions
-
O
Searching for partial, but only when it's its own word
Let's say T12 = 'Novice Dec =IF(ISNUMBER(SEARCH("nov",T12)),"5",IF(ISNUMBER(SEARCH("dec",T12)),"6","")) With the above equation, it will return "5". I want it only to return "5" if "nov" is its own word. IE in this case, it want it to return "6". Thanks for the help. Oscar- oscark37
- Thread
- case nov oscar return word
- Replies: 2
- Forum: Excel Questions
