Forum Discussion
formula
I need to match 2 columns. I need to leave blank spaces when they do not match. example: column a column b 105 105 110 113 ...
To replicate a value from List B only when it occurs in a second List A
= IF(
COUNTIFS(ListA, ListB),
ListB,
"")