Check box and Vlookup

[LordSnow548]

Hi,


I have several check boxes within a sheet that when ticked will perform a Vlookup and return the value required, this is the formula that i have that currently works as intended

=IF(C4=TRUE,(VLOOKUP(A4,Sheet2!B2:E30,4,FALSE))

What i also want to explore is the addition of the ISBLANK function so that the if the check box is not ticked it wont show FALSE in the output cell, i also want to know if i can include the TEXTJOIN function so that when several check boxes are ticked the vlookup results populate into one cell only

Thanks in advance

 

[awoohaw]

for the first question, just add an "" as your false condition action, you don't have one.

=IF(C4=TRUE,(VLOOKUP(A4,Sheet2!B2:E30,4,FALSE),"")

Do you have TEXTJOIN in Excel 2010? Maybe you need to update your excel version in your profile?

 

[LordSnow548]

Hi, I have Textjoin in my version of Excel

 

[awoohaw]

Hi, I have Textjoin in my version of Excel

and what version is that?
I don't think it is in the version you state you have on your profile:

 

[LordSnow548]

Hi its the 365 version, ive not updated things as its been a while

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Vlookups return result into one cell in their own paragraphs on check box selection
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[LordSnow548]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Vlookups return result into one cell in their own paragraphs on check box selection
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

If you dont like the post then delete it, better still why not delete the stupid number of sites youve got which will stop this stupid bollox of crossposting ********,.

 

[Fluff]

We only have one site.
I would suggest you read the rules & in future abide by them.
All sites have similar rules.

 

[LordSnow548]

We only have one site.
I would suggest you read the rules & in future abide by them.
All sites have similar rules.

If you only have one site why you bitching about cross posting then you utter nark. As for your ******** rules, I won’t abide by them.

 

[Fluff]

In that case goodbye.