IF Formula based on a Cell containing a formula

Liam2003

New Member
Hi there,

I am trying to create this formula =IF(Q11>0,1,AK11) however it appears not to work?

Q11 contains a formula {=IFERROR(INDEX(lastsaledatacust,MATCH(1,IF(lastsalecust=\$D\$5,IF(lastsaleprodcust=\$C11,1)),0),5),"")}

AK11 contains a Data Validation drop down box

Thank you.

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Liam2003

New Member
Hi there,

I am trying to create this formula in cell AL11 =IF(Q11>0,1,AK11) however it appears not to work?

The following 2 cells within this formula, these are working perfectly, just the above mentioned formula!
Q11 contains a formula {=IFERROR(INDEX(lastsaledatacust,MATCH(1,IF(lastsalecust=\$D\$5,IF(lastsaleprodcust=\$C11,1)),0),5),"")}

AK11 contains a Data Validation drop down box

Thank you.

what does:

=isnumber(q11)

return?

It returns TRUE.

Thank you

Replies
3
Views
55
Replies
5
Views
85
Replies
20
Views
168
Replies
2
Views
135
Replies
0
Views
42

1,109,336
Messages
5,528,101
Members
409,802
Latest member
joeino

This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...