Connecting Data from 2 tabs into 1 row?

[Ed_Cleary]

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!

[Mohamed_Swella1]

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