vlookup

  • Thread starter Thread starter dido22
  • Start date Start date
D

dido22

Hello, can someone help me with Vlookup please ?

I have a large table with dates (decreasing monthly) in column A, and debt
(also decreasing) in column F.

I want to lookup the date at which the debt falls to zero (or goes
negative), but Vlookup uses the first column as its 'search value' while I
need it to search in column F.

I could copy the dates to a new column G and search the array F1:G500, but
is there a more elegant way of doing this ?

Thanks

K
 
Thanks, that is what I needed

K


Spencer101 said:
Without an example workbook it's hard to provide you with the actual
formula.
But if you Google "LEFT LOOKUP CHOOSE" you will find details on how to
use the CHOOSE function with a VLOOKUP to do what you need.
Click to expand...
 
Back
Top