Thread
:
Match - #N/A
View Single Post
#
4
Domenic
Posts: n/a
I've confirmed that the formula is correct. Would you like me to send
you a sample file?
In article . com,
wrote:
Thanks for the effort, but I am still getting a #N/A error for the
Column Header formula. And I did enter it as an array formula.
I didn't try the Row Header formula - it was easier to use Conditional
Formatting to highlight the Row that I am looking for.
Will the Match function work on it's own? I suspect that is the source
of the #N/A error.
Reply With Quote