vlookup

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
 
S

Spencer101

dido22;1603621 said:
Hello, can someone help me with Vlookup please ?

I have a large table with dates (decreasing monthly) in column A, an
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' whil
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


Without an example workbook it's hard to provide you with the actua
formula.
But if you Google "LEFT LOOKUP CHOOSE" you will find details on how t
use the CHOOSE function with a VLOOKUP to do what you need
 
D

dido22

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top