Thread: =if(isna(hlookup(

Hey, I have a excel spread sheet page that looks up tabs and returns values using the below code,.

=IF(ISNA(HLOOKUP($B4,'SEP 08'!$U$2:$CS$3,2,FALSE))=TRUE,0,HLOOKUP($B4,'SEP 08'!$U$2:$CS$3,2,FALSE))

B4 represents a text value,. I.E,. AOG,.
SEPT 08 is the page name,

Anyway,. this spreed sheet has been working fine, but for some reason its not working for months Sep and October,.

To start can someone explain, exactly what the lookup is doing, as it isn't working the way i'd expect it to,.

Thanks,

Originally Posted by AOG123

Hey, I have a excel spread sheet page that looks up tabs and returns values using the below code,.

=IF(ISNA(HLOOKUP($B4,'SEP 08'!$U$2:$CS$3,2,FALSE))=TRUE,0,HLOOKUP($B4,'SEP 08'!$U$2:$CS$3,2,FALSE))

B4 represents a text value,. I.E,. AOG,.
SEPT 08 is the page name,

Anyway,. this spreed sheet has been working fine, but for some reason its not working for months Sep and October,.

To start can someone explain, exactly what the lookup is doing, as it isn't working the way i'd expect it to,.

Thanks,

Got it,. CS, is a covering range,. new columns fell out that,. i changed all to IV,. as this covers the complete range.