Vlookups return result into one cell in their own paragraphs on check box selection

**LordSnow** · 03-20-2024, 01:34 PM

I have a sheet with 6 check boxes, i have the below formula that will complete a Vlookup when the check box is ticked, what i now need to know how to do is adapt the formula to complete Vlookups when several check boxes are ticked, and then put the result of the vlookups into one cell.

This formula is the current method i am using but as you will see it only works when one check box is ticked and then populates the result into the one cell.

=IF(B2=TRUE,(VLOOKUP(Sheet2!A2,Sheet3!A2:B7,2,FALSE)),"")

Thanks in advance for your help

**AliGW** · 03-20-2024, 01:35 PM

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

**AliGW** · 03-20-2024, 01:43 PM

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...ookup.1255925/)

**LordSnow** · 03-20-2024, 02:21 PM

If you dont like the post then delete it. Forum Rules mean nothing to me and i will not obey them.

**AliGW** · 03-20-2024, 02:34 PM

Then you are not welcome here.

Thread closed.

**6StringJazzer** · 03-20-2024, 03:25 PM

Originally Posted by LordSnow

If you dont like the post then delete it. Forum Rules mean nothing to me and i will not obey them.

Very impressive. Bye!

Vlookups return result into one cell in their own paragraphs on check box selection

LinkBack

Thread Tools

Display

Vlookups return result into one cell in their own paragraphs on check box selection

Re: Vlookups return result into one cell in their own paragraphs on check box selection

Re: Vlookups return result into one cell in their own paragraphs on check box selection

Re: Vlookups return result into one cell in their own paragraphs on check box selection

Re: Vlookups return result into one cell in their own paragraphs on check box selection

Re: Vlookups return result into one cell in their own paragraphs on check box selection

Thread Information

Users Browsing this Thread

Similar Threads

IF Formula, read multiple columns and check for result and return name in other column.

[SOLVED] If the IF function result is false then check the next cell until get a true result

[SOLVED] multiple if and vlookups, return number or blank cell

IF Statement to return Vlookups vased off cell

Select multiple criteria based on check box selection and return all unique values.

check a row of data for a value return a boolean result

How do I check the conditions of 2 fields to return a result

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions