Posted to microsoft.public.excel.worksheet.functions

Rowland

external usenet poster

Posts: 18

Lookup formula

I am looking for a formula to find the first row in a column that
contains any data.I can do it with an array formula
INDEX(rng,MATCH(TRUE,rng0,0)) but was curious if some can do it without
using an array formula,perhaps with LOOKUP

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is it possible?	DakotaNJ	Excel Worksheet Functions	25	September 18th 06 09:30 PM
LOOKUP formula	Andy	Excel Worksheet Functions	2	August 19th 06 12:39 AM
Populating a field based on lookup values	Sav_C	Excel Worksheet Functions	5	August 6th 06 02:49 AM
Match then lookup	Tenacity	Excel Worksheet Functions	9	December 3rd 05 05:30 AM
How do I lookup a value in a array that is not in ascending order	John	Excel Worksheet Functions	6	June 20th 05 09:40 PM

All times are GMT +1. The time now is 08:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us