I have a cell M2 in sheetB.
I also have cell P2 in sheetA. P2 contains a value.

In SheetB cell M2 I want an equation that refers to the P2 value with the row function.

However, when I refer to =SheetA!P&ROW() then NAME error occures.

How do I write the equation with the ROW function?