View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Tim is offline
external usenet poster
 
Posts: 408
Default Using row() in conjunction with a column number.

I am working with a large database and it would be too difficult to make a
function like "=if(b13253=b13254,d13254)". I am trying to find a way to do
something like this "=if (2.row()=2.row()+1,4.row()+1". where the 2's are
column b, and the 4 is column D. I am unaware of the correct syntax and
can't find anything on the web about it. Is this possible?