VLookup Formula to Search for a Number in Row

		Microsoft Office Forums > Microsoft Excel > Excel
VLookup Formula to Search for a Number in Row

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-18-2019, 12:52 PM

baes10

Windows 7 64bit VLookup Formula to Search for a Number in Row

Office 2007

Advanced Beginner

Join Date: Dec 2017

Posts: 33

VLookup Formula to Search for a Number in Row

Hello, can you help me create a vlookup formula to find the last number >0 in a row, starting from right to left? The number highlighted in yellow is what i need. If "65" was "0" then we want the formula to pull the number "85". I hope this makes sense. Thank you! Steve

Attached Files

Test.xlsx (14.0 KB, 11 views)

« 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
Vlookup or some other formula need help	gqmallah	Excel	2	04-30-2018 01:28 AM
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
VLOOKUP Formula?	ekeithjohnson	Excel	6	08-28-2014 01:16 PM
IF + VLOOKUP formula help	skyline255	Excel	0	09-19-2012 05:05 PM
Help with VLOOKUP formula	pattyr	Excel	6	08-20-2012 02:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:22 AM.