| 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. |
| 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 | |||
Threaded Mode
