Vlookup
 

=IF(AND($B$6=65,OR($I$2="Y",$B$8="LPRE",$B$8="LPO S")),(VLOOKUP($I$7,'Price
Tables'!$E$2:$E$551,1,FALSE)),IF(AND($B$6<65,OR($I $2="Y",$B$8="LPRE",$B$8="LPOS")),(VLOOKUP($I$7,'Pr ice Tables'!$D$2:$D$551,1,FALSE)),TRUE,FALSE))

Can someone please tell me why this isn't working? Thank you

Basically, if they're over 65 look up E price table
if they're under 65, look up D price table.

Vlookup
 

=IF(AND($B$6=65,OR($I$2="Y",$B$8="LPRE",$B$8="LPO S")),VLOOKUP('Price
Tables'!$I$7,$E$2:$E$551,1,FALSE),IF(AND($B$6<65,O R($I$2="Y",$B$8="LPRE",$B$8="LPOS")),VLOOKUP($I$7, 'Price
Tables'!$D$2:$D$551,1,FALSE),""))


will return blank if no condition is true or #N/A if there is no match





--
Regards,

Peo Sjoblom



"Clara" wrote in message
...
=IF(AND($B$6=65,OR($I$2="Y",$B$8="LPRE",$B$8="LPO S")),(VLOOKUP($I$7,'Price
Tables'!$E$2:$E$551,1,FALSE)),IF(AND($B$6<65,OR($I $2="Y",$B$8="LPRE",$B$8="LPOS")),(VLOOKUP($I$7,'Pr ice
Tables'!$D$2:$D$551,1,FALSE)),TRUE,FALSE))

Can someone please tell me why this isn't working? Thank you

Basically, if they're over 65 look up E price table
if they're under 65, look up D price table.

Vlookup
 

A specific problem is that you have too many elements in the last if
statement, you need to group the true false groups better,, but I think
another issue is that your look up tables are not looking up prices. what
are you comparing I7 to in youe tables?


"Clara" wrote:

=IF(AND($B$6=65,OR($I$2="Y",$B$8="LPRE",$B$8="LPO S")),(VLOOKUP($I$7,'Price
Tables'!$E$2:$E$551,1,FALSE)),IF(AND($B$6<65,OR($I $2="Y",$B$8="LPRE",$B$8="LPOS")),(VLOOKUP($I$7,'Pr ice Tables'!$D$2:$D$551,1,FALSE)),TRUE,FALSE))

Can someone please tell me why this isn't working? Thank you

Basically, if they're over 65 look up E price table
if they're under 65, look up D price table.