I meant to add that your column index number can't be greater than the number
of columns in the table array. You have 3 in your example and only 2 columns
in the table array.
Are you sure that you want to use that formula?
You are trying to look for a value in the third column of a range that
is only two columns wide. That will always result in a #N/A.
You can not return a blank cell from a worksheet function.
But if it is OK to return an empty string, "", that will display as
blank, then you may try the following formula:
=IF(ISNA( your formula goes here), "", your formula goes here too )
This can be useful for a formult that does not always return #N/A.
Sorry about the typo.
Your solution fits like a glove.
Glad you were there. You'll make me look like a genius.
Thank you...
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.