Thread: how do i setup IF name = this then address = that
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
frederick frederick is offline
external usenet poster
  
Posts: 4
Default how do i setup IF name = this then address = that
exactly, pb i am real novice in excel, so f.e when i try with 1value it works
well but as long as i try to put more values it just wont work
=IF(I5="Frederick";Products!I3;Products!I6) works
=IF(I5="Frederick","Karim";Products!I3;Products!I6 )

Reply With QuoteReply With Quote