Custom Function Referancing Cell Value
In G1 enter =IF(H1="","",INDIRECT(H1))
"Abode" wrote:
Hello. I'm having a little trouble making a custom function that will show
the value of another cell. Basically what I want is a Function that will get
a Cell location from a neighboring cell and then use that value to output the
answer of that cell. I'm not sure if it makes any sence but I'll post an
example of what I'm hoping I can do.
Column F
Name 1
Name 2
Name 3
Column G
=TestDisplay(H1)
Column H1
(Now in this column I can type in F1 and the function in G will display
"Name 1")
I'm not sure if any of that helps afterall. But is there a way to do this.
When I've tried I get either #NAME or #VALUE errors.
|