General discussion
January 15, 2004 at 12:39 PM
graham bennett

Excel 97: Find a Value Less Than Another in Array

by graham bennett . Updated 22 years, 9 months ago

I have a two column array of 30 rows.

Each cell in Column A contains a sequential value from 61 – 90 (person’s age).

Each cell in column B contains a decreasing value that eventually goes negative (retirement savings being run down). The starting value in the first row of column B can vary, which means that the cell in Column B that goes negative can change.

I want to be able to find the value for the cell in Column A alongside the same row that the cell in column B goes negative.

I have attempted to use VLOOKUP but seem unable to use a ‘less than zero’ value.

Your assistance will be appreciated.

This discussion is locked

All Comments