Vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=IF(AND($B$6>=65,OR($I$2="Y",$B$8="LPRE",$B$8="LPOS")),(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,'Price 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.
 
=IF(AND($B$6>=65,OR($I$2="Y",$B$8="LPRE",$B$8="LPOS")),VLOOKUP('Price
Tables'!$I$7,$E$2:$E$551,1,FALSE),IF(AND($B$6<65,OR($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
 
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?
 
Back
Top