Microsoft Office Forums - View Single Post - VLookup Formula to Search for a Number in Row

Thread: VLookup Formula to Search for a Number in Row

View Single Post

Old

01-18-2019, 01:01 PM

NBVC

NBVC is offline

NBVC uses Windows 10

Windows 10 NBVC uses Office 2013

NBVC uses Office 2013

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

NBVC will become famous soon enough

NBVC will become famous soon enough

Default

Does this work?

=LOOKUP(2,1/(E9:N9>0),E9:N9)

Reply With Quote