Thread: can't get lookup to work when i need it to report from a cell ref
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default can't get lookup to work when i need it to report from a cell ref
Hi,
You can concatonate IF statements using the '&' symbol, and have lots. Not
sure how many, but more than 8.
Your formula would look something like:
=IF(C98="A",$F$28,"")&IF(C98="B",$F$37,"")&IF(C98= "C",$F$46,"")&IF(C98="D",$F$55,"")&IF(C98="E",$F$6 4,"")&IF(C98="F",$F$73,"")&IF(C98="G",$F$82,"")&IF (C98="H",$F$91,"")&IF(C98="I",Whatever,"")

Regards - Dave.
Reply With QuoteReply With Quote