I have explained on the attached sheet what I want to accomplish.
What I basically want to do is have VLookup search criteria and subtract values, and when no data is found in the search criteria, it needs to give a Blank ("").
I have explained on the attached sheet what I want to accomplish.
What I basically want to do is have VLookup search criteria and subtract values, and when no data is found in the search criteria, it needs to give a Blank ("").
Last edited by mrcois; 06-30-2010 at 03:29 PM.
Put -F2 INSIDE:
=IF(ISNA(VLOOKUP(A2;$J$3:$L$30;3;0));"";VLOOKUP(A2;$J$3:$L$30;3;FALSE)-F2)
Also.. Slightly better to use MATCH than VLOOKUP for criteria:
=IF(ISNA(MATCH(A2;$J$3:$J$30;0));"";VLOOKUP(A2;$J$3:$L$30;3;FALSE)-F2)
(replace ; with , if needed)
Put the F2 inside the last closing bracket:
=IF(ISNA(VLOOKUP(A2,$J$3:$L$30,3,0)),"",VLOOKUP(A2,$J$3:$L$30,3,FALSE)-F2)
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.
Thanks for the replies....
I do I change the formula to STILL show a Blank when there is no value in F2?
Do you mean leave cell blank until F2 is filled in?
=IF(F2="","",IF(ISNA(VLOOKUP(A2,$J$3:$L$30,3,0)),"",VLOOKUP(A2,$J$3:$L$30,3,FALSE)-F2))
Thanks a million for your input...
NBVC's formulas is what really worked for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks