Thread: [Solved] Help using If and Vlookup
View Single Post
 
Old 08-04-2014, 11:03 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Let's look at the equations for Medica...

=IF(OR($Q68="Waived",$F68=" "),0,VLOOKUP($F68,AN$3:AO$54,2))

F68 is never going to equal " " (i.e. a single space) or even "" (blank) unless you modify the cell content (which I don't advise).

Also, it is stated that "waived" is to be indicated with a "w", so the equation should reflect that.

I don't understand what you are trying to do there. Do you intend to only calculate ages for those that are no longer going to waive coverage?

The equation for dependent children doesn't have to be a lookup since all the plans charge a certain cost per each up to three. Thus:

VLOOKUP($P68,AN$4:AO$54,2) can become MIN($P68,3)*AO$4

Other than that...I would definitely use tabs to separate your tables and get rid of the white space to the top left.
Reply With Quote