Hello I have data in 2 cells and I want to combine it in another cell on a different tab.
However there would be multiples of this data repeated in the combined cell. Once new data is entered in the row below for the 2 cells i want the cell to display that.
Currently i have this
=IF(ISBLANK('Inspection Record'!$H3),'Inspection Record'!$H$2 & "," & " " & "DN" &" " &'Inspection Record'!F$2,'Inspection Record'!$H3 & "," & " " & "DN" &" " &'Inspection Record'!F3)
So if H3 is blank I want to display what is in H2 and F2 until data is put into H3 then i want to display that and so on. So if H4 is blank it will display H3 and F3.
Is this possible with a formula ?
Any help would be appreciated
Thank you
Bookmarks