Thread: Can you use Concatenate with the If function with vlookup in the i
View Single Post
  #1   Report Post  
simoneaux
 
Posts: n/a
Default Can you use Concatenate with the If function with vlookup in the i
This is my current formula =IF(VLOOKUP($A2,'Canyon
Runner'!$A$4:$J$3001,7)=0,"",(VLOOKUP($A2,'Canyon
Runner'!$A$4:$J$3001,7)))IF(VLOOKUP($A2,'Canyon
Runner'!$A$4:$J$3001,3)=0,"",(VLOOKUP($A2,'Canyon Runner'!$A$4:$J$3001,3)))

I need to use the concatenate function with 3 cells. Is it possible and can
you give me some help? Thanks.
Reply With QuoteReply With Quote