Excel VLOOKUP - Return cells that are not blank from range of specified cells

p45cal · #7 04-14-2022, 03:07 AM

If you've got the LET and FILTER functions available in your version of Excel you can try:

Code:

=IFERROR(LET(b,Form1!$A:$AK,a,INDEX(b,MATCH(A219,INDEX(b,0,1)),{11,14,15,16,17,18,19,20}),INDEX(FILTER(a,NOT(ISBLANK(a))),1)),"")

where the {11,14,15,16,17,18,19,20} is the column numbers of interest where you add the column numbers at will. If you're looking for the columns to be searched in a different order then change the order in the curly brackets.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
have a formula that combines two cells return a zero instead of a blank cell	Kubi	Excel	3	08-07-2017 11:52 PM
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug)	slaycock	Word VBA	0	02-18-2017 07:00 AM
Vlookup fill down blank cells in column	mbesspiata	Excel Programming	8	09-26-2016 04:44 AM
Excel Formula: return a range of cells that match	tinfanide	Excel	4	08-30-2014 07:03 AM
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM