I am using the following formula =IF(ISBLANK(C5),"",LOOKUP(C5,$M$47:$M$80,$N$47:$N$80)). Works good except on the cells that are blank I get #N/A. For example if I point the formula to c6 and it blank it returns the error.
Thank for helping.
I am using the following formula =IF(ISBLANK(C5),"",LOOKUP(C5,$M$47:$M$80,$N$47:$N$80)). Works good except on the cells that are blank I get #N/A. For example if I point the formula to c6 and it blank it returns the error.
Thank for helping.
keep your cursor on the c6 and press delete. there may some unseen values in this cell
If your problem is not solved, upload a sample workbook with sample data and your desired results
In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Hello & Welcome to the Board,
Maybe try...
=IF(ISNA(LOOKUP(C5,$M$47:$M$80,$N$47:$N$80)),"",LOOKUP(C5,$M$47:$M$80,$N$47:$N$80))
HTH
Regards, Jeff
No hidden values but I do have a formula, the result of the formula is nothing (a blank cell).
Works great, thank for helping.
You're welcome and glad it worked for you![]()
For the sake of explanation...Originally Posted by dcoleman5
ISBLANK treats Null Strings ("") as non-blank (ie FALSE), COUNTBLANK does not ... a true Blank is a cell devoid of all content, a Null String is a 0 Length Text string.
Another method of the same would be:![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks