Hi All,
I have been trying to figure out the correct formula to use but I am getting stuck. Hopefully someone can help!
I have four columns A-D. In column A I need to pull in the correct sector from column B but Some cells i am not able to pull data in so the following words below show up. Basically if the below three texts show up in that cell, i need to move over to column C but that also appears to have the same issue and from there will need to move to column D and pull the sector from there.
So far I have the formula
=IF(M5="#N/A N/A",N5,IF(M5="#N/A Field Not Applicable",N5,IF(M5="N/A Invalid Security",N5,IF(N5="#N/A N/A",O5,IF(N5="#N/A Field Not Applicable",O5,IF(N5="N/A Invalid Security",O5,M5))))))
But when i get to the ones that are invalid and have either of those three words appear the If statement doesn't work.
Can somebody help?
Thanks for your help!!!
I have been trying to figure out the correct formula to use but I am getting stuck. Hopefully someone can help!
I have four columns A-D. In column A I need to pull in the correct sector from column B but Some cells i am not able to pull data in so the following words below show up. Basically if the below three texts show up in that cell, i need to move over to column C but that also appears to have the same issue and from there will need to move to column D and pull the sector from there.
#N/A Invalid Security |
#N/A Field Not Applicable |
#N/A N/A |
So far I have the formula
=IF(M5="#N/A N/A",N5,IF(M5="#N/A Field Not Applicable",N5,IF(M5="N/A Invalid Security",N5,IF(N5="#N/A N/A",O5,IF(N5="#N/A Field Not Applicable",O5,IF(N5="N/A Invalid Security",O5,M5))))))
But when i get to the ones that are invalid and have either of those three words appear the If statement doesn't work.
Can somebody help?
Thanks for your help!!!