I am using this formula:
=IF(O6>0,"",(VLOOKUP(A6,Material!A2:G43,7,FALSE)))/2000*O6
and it produces #N/A in the cell that contains this formula. If cell A6 has an item selected in it I made from data validation-list then the output is $0.00.
How can eliminate anything from showing if the list is blank in cell A6?Thanks for helping!!
Last edited by ge0rge; 03-26-2009 at 10:17 AM.
Try this:
=IF(OR(O6>0,A6=""),"",VLOOKUP(A6,Material!A2:G43,7,FALSE)/2000*O6)
Does that help?
It semi-works. It does get rid of the #N/A. When I select a material in my list it then show $0.00 which is good. As soon as I enter a number into O6 the $0.00 found in AD6(cell containing your formula) goes away and the computation is not performed.
Still not really sure what you're looking to do.
Per you original formula, if O6>0...don't perform a calculation.
In this formula:
If O6>0 or A6 does not have a value selected,=IF(O6>0,A6=""),"",VLOOKUP(A6,Material!A2:G43,7,FALSE)/2000*O6)
then no calculation is performed.
Can you described the rules?
Is there for sure a match for A6 in Material! sheet?
Try:
=IF(ISNUMBER(MATCH(A6,Material!A2:G43,0)),IF(OR(O6>0,A6=""),"",VLOOKUP(A6,Material!A2:G43,7,FALSE)/2000*O6),"")
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 formula produces a blank cell. Here is a sample.
Try:
=IF(AND(O3>0,A3<>""),VLOOKUP(A3,Materials!$A$2:$G$43,7,FALSE)/2000*O3,"")
in AD3, copied down
That worked. Thanks to all for the help!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks