Thread: VLookup Formula to Search for a Number in Row
View Single Post
 
Old 01-18-2019, 12:52 PM
baes10 baes10 is offline Windows 7 64bit Office 2007
Advanced Beginner
  
Join Date: Dec 2017
Posts: 33
baes10 is on a distinguished road
Default 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
File Type: xlsx Test.xlsx (14.0 KB, 11 views)
Reply With Quote