VLOOKUP return #N/A
On Fri, 23 Jan 2009 21:22:36 -0800, "William Beard"
wrote:
If VLOOKUP(A6,B6:C30,3,FALSE) returns #N/A (error value),
can I convert that #N/A into a blank cell?
If so, how do I do it?
Thanks
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.
Hope this helps / Lars-Åke
|