I am trying to use a formula that will start at the top of a column and work downward until it finds the first negative number. Once it find this number I want it to return the value 1 column to the left using a vlookup. Is this possible? Also, it is possible that it may not find a negative number and I need to be able to return a response if this is the case (I guess I'll use an IF statement).
If anyone can help I'd really appreciate it.
Thanks,
Jeff
Bookmarks