#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Does this work?
=LOOKUP(2,1/(E9:N9>0),E9:N9) |
#3
|
|||
|
|||
You are so awesome! Works perfect. Thank you!
|
#4
|
|||
|
|||
Sorry, I've got a follow up question. The formula works perfectly in excel but it does not in google sheet.
Any idea why? Thanks! |
#5
|
||||
|
||||
Perhaps ask a Google sheet forum?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#6
|
|||
|
|||
In Google Sheets, this works, if confirmed by Ctrl-Shift-Enter:
Code:
Lookup(9.9E+307,if(E9:N9>0,E9:N9))) |
|
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 |