Can you use Concatenate with the If function with vlookup in the i

[Guest]

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.

 

[Harlan Grove]

simoneaux wrote...

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)))

This can't be your formula bacause the second IF can't immediately
follow a right parenthesis. Is your formula actually

=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.

Do you mean something like

=IF(VLOOKUP($A2,'Canyon Runner'!$A$4:$J$3001,7)=0,"",
VLOOKUP($A2,'Canyon Runner'!$A$4:$J$3001,7)
&VLOOKUP($A2,'Canyon Runner'!$A$4:$J$3001,3)
&VLOOKUP($A2,'Canyon Runner'!$A$4:$J$3001,5))

?

 

[Guest]

I figured it out this is the formula I used. Thanks.

=(IF(VLOOKUP($A$2,'Fast Scout'!$A$4:$J$3001,7)=0,"",(VLOOKUP($A$2,'Fast
Scout'!$A$4:$J$3001,7))))&" Equip: "&(IF(VLOOKUP($A$2,'Fast
Scout'!$A$4:$J$3001,3)=0,"",(VLOOKUP($A$2,'Fast Scout'!$A$4:$J$3001,3))))&"
Notes: "&(IF(VLOOKUP($A$2,'Fast
Scout'!$A$4:$J$3001,4)=0,"",(VLOOKUP($A$2,'Fast Scout'!$A$4:$J$3001,4))))