ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Obscure Function (https://www.excelbanter.com/excel-worksheet-functions/131541-obscure-function.html)

KW_Counter

Obscure Function
 
I used to use a funtion that would look in a one cell to find out what column
or row to use in a formula. I can't remember what it was called so I can't
even look it up in help. Anyone got a clue what I am asking about?
Thanks,
KW_Counter

Niek Otten

Obscure Function
 
Maybe you mean the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"KW_Counter" wrote in message ...
|I used to use a funtion that would look in a one cell to find out what column
| or row to use in a formula. I can't remember what it was called so I can't
| even look it up in help. Anyone got a clue what I am asking about?
| Thanks,
| KW_Counter



KW_Counter

Obscure Function
 
I do! I do!
Many Thanks, Niek

"Niek Otten" wrote:

Maybe you mean the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"KW_Counter" wrote in message ...
|I used to use a funtion that would look in a one cell to find out what column
| or row to use in a formula. I can't remember what it was called so I can't
| even look it up in help. Anyone got a clue what I am asking about?
| Thanks,
| KW_Counter





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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com