Thread: Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
clara clara is offline
external usenet poster
 
Posts: 252
Default 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.