Thread: If, VLookup, Index, or a combination of all of them?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LisaM LisaM is offline
external usenet poster
  
Posts: 24
Default If, VLookup, Index, or a combination of all of them?
"Teethless mama" wrote:

="07."&IF(A2=1,1,"")&IF(B2=1,2,"")&IF(C2=1,3,"")&I F(D2=1,4,"")

adjust cell references to suit

Thank you very much for your help!
Reply With QuoteReply With Quote