How would I ammend the statement below so that if there was no infomation to
return the resulting text would show blank instead of #N/A?
=INDEX(Schedule!$B$49:$B$102,MATCH("CKT2",Schedule!$C$49:$C$102,FALSE))
How would I ammend the statement below so that if there was no infomation to
return the resulting text would show blank instead of #N/A?
=INDEX(Schedule!$B$49:$B$102,MATCH("CKT2",Schedule!$C$49:$C$102,FALSE))
=IF(ISNA(MATCH("CKT2",Schedule!$C$49:$C$102,0)),"",INDEX(Schedule!$B$49:$B$102,MATCH("CKT2",Schedule!$C$49:$C$102,0)))
--
Regards,
Peo Sjoblom
(No private emails please)
"Sonya" <[email protected]> wrote in message
news:[email protected]...
> How would I ammend the statement below so that if there was no infomation
> to
> return the resulting text would show blank instead of #N/A?
>
> =INDEX(Schedule!$B$49:$B$102,MATCH("CKT2",Schedule!$C$49:$C$102,FALSE))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks