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

		Microsoft Office Forums > Microsoft Excel > Excel
Excel VLOOKUP - Return cells that are not blank from range of specified cells

FAQ

Thread Tools

Display Modes

04-14-2022, 12:17 AM

Pecoflyer

Windows 7 64bit Excel VLOOKUP - Return cells that are not blank from range of specified cells

Office 2010

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Quote:

Originally Posted by ArviLaanemets

The first formula has 7 nested IF's, what is a max number of nesting allowed!

As a matter of fact modern versions of XL ( starting at 2007 I think) will accept 64 levels of nested IF

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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