Lookup to find first non-blank cell

		Microsoft Office Forums > Microsoft Excel > Excel
Lookup to find first non-blank cell

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-23-2018, 10:26 PM

xor

Windows 10 Lookup to find first non-blank cell

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

@mactoolsix

I know you have got a solution already but would just mention that you could also have made a small change to your own formula like this:

=LOOKUP(2,1/ISNUMBER(N14:N68),N14:N68)

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup and replace cell values	rgauss	Excel	3	10-03-2016 04:01 PM
LOOKUP - Complex lookup with 2 lookups in 1 cell	sglandon	Excel	6	05-05-2016 09:44 AM
Formulato say if cell is blank do this, if not blank do this.	mbesspiata	Excel	1	01-17-2015 05:02 AM
Place 0 in blank cell	mbesspiata	Excel	5	06-20-2014 07:00 PM
won't show blank cell	bhum	Excel	2	01-28-2014 02:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:20 AM.