Help

Connecting Data from 2 tabs into 1 row?

786 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ed_Cleary
4 - Data Explorer
4 - Data Explorer

I want to collate data from two different tabs into a 3rd tab, but have the data synch across the row. For example: Client A info for Project Name from Tab 1 and Client A Invoice Number from Tab 2, and for these to be combined into Tab 3.

I am using LookUp to collect the data into the 3rd Tab but the info isn’t pairing together. The data is falling into different rows. Does anyone know of a way to put both lookup info into the one row?

All help is welcomed!

1 Reply 1

Hi @Ed_Cleary,

I believe you are looking for the formula CONCATENATE()

You can use the formula like this

CONCATENATE({Project Name},"-",{Invoice No.})

Let me know if you need any help with it

Best Regards,
Mo