If it can not locate the correct responce I want it the formula cell to be blank. How do I adjust my formula to do this?
This is the forumal I am currently using
=VLOOKUP(A26,Subs!A:F,5,0)
I have also tried this one as well
=IF(ISNA(VLOOKUP(A6,Subs!A:E,5,0))+(VLOOKUP(A6,Subs!A:E,5,0)=""),"",VLOOKUP(A6,Subs!A:E,5,0))
But neither seem to be working.
Thanks,
Last edited by JEllison; 11-13-2008 at 04:25 PM.
=IF(ISNA(VLOOKUP(A26,Subs!A:F,5,0)),"",VLOOKUP(A26,Subs!A:F,5,0))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
that works. Thanks.
Please mark your thread as solved...
Click Edit on original post and click Go Advanced.
Select [Solved] from the prefix drop down and click Submit.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks