View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JJ[_3_] JJ[_3_] is offline
external usenet poster
 
Posts: 5
Default Referencing a cell in another sheet through the use of variables

Hi,

I have a cell which refers to a cell in a different sheet like the
following:

='SheetB'!N5

Now, N is a variable which is the content of another cell (say H10),
and 5 is the actual row of the cell.
I am trying to use string concat so that the cell can display the
result of 'SheetB'!(Content of H10)(Row) but I am not having much
luck.

Which formula should I create ?

Thanks/Brgds
Joćo