Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
simoneaux wrote...
This is my current formula =IF(VLOOKUP($A2,'Canyon Runner'!$A$4:$J$3001,7)=0,"",(VLOOKUP($A2,'Cany on Runner'!$A$4:$J$3001,7)))IF(VLOOKUP($A2,'Canyon Runner'!$A$4:$J$3001,3)=0,"",(VLOOKUP($A2,'Cany on 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)) ? |
#3
|
|||
|
|||
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)))) "Harlan Grove" wrote: simoneaux wrote... This is my current formula =IF(VLOOKUP($A2,'Canyon Runner'!$A$4:$J$3001,7)=0,"",(VLOOKUP($A2,'Cany on Runner'!$A$4:$J$3001,7)))IF(VLOOKUP($A2,'Canyon Runner'!$A$4:$J$3001,3)=0,"",(VLOOKUP($A2,'Cany on 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)) ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate Function will not work | Excel Discussion (Misc queries) | |||
I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
Regarding IF function or vLOOKUP function | Excel Worksheet Functions |