hi guys
i have this formula which works well
which returns the value 0 if nothing selcted![]()
=VLOOKUP($E29,$B:$E,2,0)
how can i keep this blank if nothing is selected
thanks in advance
hi guys
i have this formula which works well
which returns the value 0 if nothing selcted![]()
=VLOOKUP($E29,$B:$E,2,0)
how can i keep this blank if nothing is selected
thanks in advance
Last edited by stevesunfold; 11-23-2008 at 10:13 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks