Sorry, Pehl,
I just reread the post, and think I picked on the wrong one. To confirm, it's the formula ='SHEET 1'!F20 that may return the N/A value?
If so, try
Let us know,=if(isna('SHEET 1'!F20,"", 'SHEET 1'!F20))
Sorry, Pehl,
I just reread the post, and think I picked on the wrong one. To confirm, it's the formula ='SHEET 1'!F20 that may return the N/A value?
If so, try
Let us know,=if(isna('SHEET 1'!F20,"", 'SHEET 1'!F20))
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
Posting Permissions
Reply With Quote