custom function in excel

[cwunderlich]

Is there a way to have a custom function look at another sheet within the same wkbk and manipulate data within that other sheet and return a value back to the original cell??

I thought there was an easy way, but I must be missing something...

Thanks!

 

[cwunderlich]

bump

 

[cwunderlich]

anyone???

 

[cwunderlich]

nevermind, figured it out using a combination of max, indirect, address, and match functions....