Not sure if this can be done with cell formulas...

I want to create a function so that given a range that is 20 x 30, it
would return the row and column coordinated for each cell containing a
particular value (the letter "N").

Any idea if this doable with functions? or would this require VBA?