Here is the equation that I need to edit. My only issue is that sometimes the W19 is a blank cell and so that annoying Value error shows up. How should I reword the formula to take care of that?
Thanks for your time
=IF(E19="","",VLOOKUP(E19,parts_list,21,FALSE))*W19
Maybe:
=IF(E19="","",VLOOKUP(E19,parts_list,21,FALSE))*(W19+0)
...or:
=IF(OR(E19="",W19=""),"",VLOOKUP(E19,parts_list,21,FALSE))*W19
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
They dont work
Actually I think it has something to do with the sheet not updating its refs
I'd be happy to look for you. Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
Here it is. Im sure the vlookups wont work for you but you get the idea. Too be honest, I cant understand why your formula or mine wont work. I am probably missing something critical. Anyways, thanks for your help.
Forum Help.xlsx
Can you not use the ISERROR inside a IF!
IF(ISERROR(Your_Formula),"",Your_Formula)
Edit: Just noticed Excel 2010: IFERROR
Last edited by Kevin UK; 10-04-2012 at 12:46 PM.
I cant get it to work. can you?
In X8 and copy down, if we are in the same area!
=IFERROR(IF(OR(E8=" ",W8=" "),"",VLOOKUP(E8,parts_list,21,FALSE))*W8,"")
Ah order of operations
Thanks alot for the great formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks