Skip to main content

Connecting Data from 2 tabs into 1 row?

  • January 6, 2020
  • 1 reply
  • 6 views
E

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

    Mohamed_Swella1
    Forum|alt.badge.img+17

    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

    Terms & ConditionsAccessibility statement