vlookup adding data to a field with existing data?

Barbara Witt

@KDM Yes, that worked after I moved the second ) to the back. And now the delimiter shows up, too.

Here is a screen shot. The comma is after the room number.

=IF([Project Number]@row <> "", JOIN(COLLECT({DAX Ambient Inventory Install Location}, {DAX Ambient Inventory Project #}, [Project Number]@row), ", "))

Perfect. Thanks so much - as always.

Best regards, Barbara

Kelly Moore

You're welcome. As always, so very glad to help