Book2.xlsx
in column h have formula below.
=B2-IF(ISERROR(VLOOKUP(A2,play,2,FALSE)),0,VLOOKUP(A2,play,2,FALSE))
would like to return value of B2 if not in range. and cell blank if nothing in B2.
thank you
Book2.xlsx
in column h have formula below.
=B2-IF(ISERROR(VLOOKUP(A2,play,2,FALSE)),0,VLOOKUP(A2,play,2,FALSE))
would like to return value of B2 if not in range. and cell blank if nothing in B2.
thank you
Last edited by zappyzoo; 11-10-2013 at 06:08 PM.
Please post a sample sheet with some more explanation - Thx
Explain More Please!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks