Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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.
  #2   Report Post  
Harlan Grove
 
Posts: n/a
Default

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   Report Post  
simoneaux
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenate Function will not work Chuck W Excel Discussion (Misc queries) 4 February 1st 05 12:41 AM
I want to use Vlookup function and AND function in a single formu. prakash Excel Worksheet Functions 3 January 25th 05 08:11 AM
carrying a hyper link when using the vlookup function mike Excel Worksheet Functions 1 November 19th 04 04:49 AM
carrying a hyper link when using the vlookup function mike Excel Worksheet Functions 2 November 18th 04 05:22 PM
Regarding IF function or vLOOKUP function wuwu Excel Worksheet Functions 2 November 13th 04 02:38 PM


All times are GMT +1. The time now is 06:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"