If statement working only once

L

Lime

=if(B4>='[CNAM for Ranges.xls]Sheet1'!$B$2:$B$66,if=if(B4<='[CNAM for
Ranges.xls]Sheet1'!$C$2:$C$66,offset('CNAM for
Ranges.xls]sheet1'$B$2:$B$66,0,2),""))

The above only works once for a number falling in this range. all others
that fall in the range come back Blank. Blank sould only come back if it if
false.

Am I missing something??

Any help is appreciated...

Lime
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Urgent help with Excel formula. Please please help 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Code works but goes into endless loop and crashes 1
Modify working code to expand the output. 5
Code copies between key word is in reverse order 5
VLookup formula question 2
Using COUNTIF with criteria in an adjacent column? 5
Vlookup not returning correct value 4

Top