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-19-2019, 01:16 PM

alpha

alpha is offline

alpha uses Windows 10

Windows 10 alpha uses Office 2010 64bit

alpha uses Office 2010 64bit

Office 2010 64bit

Novice

Join Date: Jun 2018

Posts: 18

alpha is on a distinguished road

Default

In Google Sheets, this works, if confirmed by Ctrl-Shift-Enter:

Code:

Lookup(9.9E+307,if(E9:N9>0,E9:N9)))

Reply With Quote