View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dch3 dch3 is offline
external usenet poster
 
Posts: 15
Default Passing a row to a function

I need to take the row value of the cell in which a function appears and pass
that value into the function itself. As in the example below, cells A1, A2,
A3 all contain the function getName(), I would like getName() to evaluate
differently based on the row number. Is this possible?

COLUMN
ROW A B
1 =getName()
2 =getName()
3 =getName()