If one cell is blank, Show what is in the adjacent cell.

[Iraelaemei]

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

 

[MrJoosten]

Not sure if i follow. But try this in column C:

=IF(A2:A8 = "",B2:B8,"")

 

[Iraelaemei]

Thanks for the reply, I realized that my post wasn't clear. I want the results of what is blank to be displayed in one cell.

 

[Joe4]

One way is to use VBA and create your own function that does it.

Here is a function that I came up with:

Function ReturnBlanks(myRange As Range) As String

    Dim cell As Range
    Dim myString As String
    
    For Each cell In myRange
        If cell = "" Then myString = myString & cell.Offset(0, 1).Value & ","
    Next cell
    
    If Len(myString) > 0 Then ReturnBlanks = Left(myString, Len(myString) - 1)
        
End Function

So let's say that the data sample you posted is in range A1:B8. I wrote it so you just reference column A in the formula, and it will return the corresponding column B entries for the blank column A values.

So, you would enter a formula like this:
=ReturnBlanks(A2:A8)

which will return:
Deed,Truth-In-Lending

 

[Iraelaemei]

One way is to use VBA and create your own function that does it.

Here is a function that I came up with:

Function ReturnBlanks(myRange As Range) As String

    Dim cell As Range
    Dim myString As String
    
    For Each cell In myRange
        If cell = "" Then myString = myString & cell.Offset(0, 1).Value & ","
    Next cell
    
    If Len(myString) > 0 Then ReturnBlanks = Left(myString, Len(myString) - 1)
        
End Function

So let's say that the data sample you posted is in range A1:B8. I wrote it so you just reference column A in the formula, and it will return the corresponding column B entries for the blank column A values.

So, you would enter a formula like this:
=ReturnBlanks(A2:A8)

which will return:
Deed,Truth-In-Lending

Thank you so much, that solves my issue!

 

[Joe4]

You are welcome!