Thread: can't get lookup to work when i need it to report from a cell ref
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
welshmatt welshmatt is offline
external usenet poster
  
Posts: 3
Default can't get lookup to work when i need it to report from a cell
Thankyou very much!!!
Extremelly helpful
I'll be using this again and again

"Dave" wrote:

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