Iraelaemei
New Member
- Joined
- Nov 13, 2014
- Messages
- 34
Sorry if the title is misleading.
What I am wanting to do is for the below image, if there is a blank in the 'Do we have it' column, I want to return what is in the Document column. When I tried a nested IF statement, it would only return what the first blank showed, and I need to show all of the blanks.
Thanks
What I am wanting to do is for the below image, if there is a blank in the 'Do we have it' column, I want to return what is in the Document column. When I tried a nested IF statement, it would only return what the first blank showed, and I need to show all of the blanks.
Thanks
Last edited: