Forum Discussion
tsweeney
Jun 22, 2023Copper Contributor
Conditionally Add Value to Column Based on Separate Column
Hello, I am trying to format a spreadsheet with a large list of addresses. In one column, there is a complete list of addresses. In another, I am trying to list days in which each address should ...
NikolinoDE
Jun 22, 2023Platinum Contributor
As far as I could gather from the problem, here is a formula you might use in column B:
=IF(A1<>"", VLOOKUP(A1, $D$1:$E$5, 2, FALSE), "")
=IF(A1<>"", VLOOKUP(A1, $D$1:$E$5, 2, FALSE), "")