Dlookup, if column "A" is Blank Then look the value in "B"

[shukoor]

Can yo

Private Sub vocab_AfterUpdate()
Item = DLookup("item", "master", "vocab='" & vocab & "'") if it is blank, then look the value in the next column "Itemsecondary description"

 

[JonXL]

Quite easily. One approach that should work:

DLookup("Nz([item],[Item secondary description])", "master", "vocab='" & vocab & "'")

 

[Micron]

As long as secondary is never null, I guess?