-
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.
dsp
-
N
Help Evaluation Really Long Formula (Nested Ifs/Vlookups)
Hi All, I know this is a big ask, but I'm really having trouble evaluating a formula to determine where an error is. The formula is returning 4.5 which is the value in AQ10, but it should return a 7.5 which is the value in DashboardH8. Here is the formula...- nirvehex
- Thread
- dsp formula returning vlookupa10 wos
- Replies: 5
- Forum: Excel Questions
-
N
Help with If FALSE Formula Wrapping
Hi, Question: I have a formula that works, but I want to wrap it and add a FALSE CONDITION in case I get a FALSE. Here is the working formula, but it gives me a FALSE...- nirvehex
- Thread
- condition dsp false formula onlyaf
- Replies: 0
- Forum: Excel Questions
-
N
if And
Hi, This code should return the value in AQ10, but for some reason I'm getting a #VALUE error. =IF(AND(VLOOKUP(A10,'WOs (DSP Only)'!A:B,2,FALSE)=VLOOKUP(A10,'WOs (DSP Only)'!A:C,3,FALSE)=VLOOKUP(A10,'WOs (DSP Only)'!A:D,4,FALSE)=VLOOKUP(A10,'WOs (DSP Only)'!A:E,5,FALSE)=VLOOKUP(A10,'WOs (DSP...- nirvehex
- Thread
- =ifandvlookupa10 dsp error reason wos
- Replies: 3
- Forum: Excel Questions
-
N
Help Rearranging If Statement
Hi, I'm trying to rearrange my if statement and I'm getting lost in it... Here's the code broken apart: =IF(OR(F6="Y",AN6<=6),AQ6, IF(AND(O6="N",SEARCH("Comp",D6),LEFT(D6,2)+0>24,AQ6>=7.5),AQ6, IF(AND(O6="N",SEARCH("Comp",D6),LEFT(D6,2)+0>24), IF(OR(AND(VLOOKUP(A6,'WOs (DSP...- nirvehex
- Thread
- dsp iforandvlookupa6 rearrange wos
- Replies: 1
- Forum: Excel Questions
-
N
Why Am I getting too many arguments for function
Hi, I feel like I've rewritten and modified this formula over and over again, but can't figure out where I'm missing something. I'm getting a "too many arguments for this function" error for the following nested if...- nirvehex
- Thread
- arguments dsp error function onlyaf
- Replies: 1
- Forum: Excel Questions
-
N
Why is Nested If Statement Giving me a False
Hi, I'm trying to figure out why this nested if is giving me a false: =IF(OR(F3="Y",AN3<=6),AQ3,IF(AND(O3="N",SEARCH("Open",D3),AQ3>=3),AQ3,IF(AND(SEARCH("Open",D3),O3="N"),IF(OR(AND(VLOOKUP(A3,'WOs (DSP Only)'!A:B,2,FALSE)>=3,(365/((AN3*AQ3)/VLOOKUP(A3,'WOs (DSP...- nirvehex
- Thread
- code combine dsp false onlyaf
- Replies: 5
- Forum: Excel Questions
-
N
Why am I getting a circular reference error?
Hi, I'm having trouble figuring out how to revise this formula to get rid of the circular reference error Excel is telling me I have: =IF(OR(F2="Y",AN2<=6),AQ2,IF(AND(O2="N",SEARCH("Open",D2),AQ2>=3),AQ2,IF(AND(O2="N",SEARCH("Open",D2)),IF(AND(VLOOKUP(A2,'WOs (DSP...- nirvehex
- Thread
- circular dsp error formula reference
- Replies: 10
- Forum: Excel Questions
-
N
With Range and AutoFill Question
Hi, I have a simple with formula but it's not copying down correctly. Sheets("WOs (DSP Only)").Select With Worksheets("WOs (DSP Only)") With .Range("A2:A" & Lastrow) .Formula = "=L2&""-""&K2&""-""&Z2&""-""&X2" End With With .Range("B2:B" & Lastrow) .FormulaArray =...- nirvehex
- Thread
- .formulaarray downward dsp end lastrow
- Replies: 2
- Forum: Excel Questions
-
N
Filter, Copy, Paste, Array Formulas
Hi, I'm trying to write some VBA code (and it's been awhile) to do the following: I have a tab called 'WOs' and another tab called 'WOs (DSP Only)'. I'm trying to first filter on the 'WOs' tab on column P to select only "DSP" and "REC". Then I'd like to copy all data on the 'WOs' tab and...- nirvehex
- Thread
- copy data dsp tab wos
- Replies: 3
- Forum: Excel Questions
