ExcelBanter - Passing a row to a function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Passing a row to a function (https://www.excelbanter.com/excel-worksheet-functions/101957-passing-row-function.html)

dch3

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()

Barb Reinhardt

Passing a row to a function

row()?

"dch3" wrote:

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()

dch3

Passing a row to a function

That will work. In the future, you may want to elaborate a little bit more. I
didn't understand your response until I opened Excel and tried the function.
I obviously wasn't aware that it was a valid Excel function.

"Barb Reinhardt" wrote:

row()?

"dch3" wrote:

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()

All times are GMT +1. The time now is 01:41 PM.