View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mangesh Yadav via OfficeKB.com Mangesh Yadav via OfficeKB.com is offline
external usenet poster
 
Posts: 3
Default If within an If...

=IF(F56="","",if(P56=10.1,(VLOOKUP(P56,$A$56:$E$20 0,5,0)),(VLOOKUP(N56,$A
$56:$E$200,5,0))))

- Mangesh

--
Message posted via http://www.officekb.com