|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 14th 12, 12:52 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
vlookup
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 
|
| Ads |
|
#2
July 14th 12, 07:19 PM
|
|||
|
|||
|
Quote:
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.
|
|
#3
July 15th 12, 01:45 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
vlookup ---- Thanks
Thanks, that is what I needed
K "Spencer101" > wrote in message ... > > dido22;1603621 Wrote: >> 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 > > > 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. > > > > > -- > Spencer101
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Vlookup problem - unable to get the vlookup property | Fred | Excel Programming | 2 | August 22nd 08 05:23 PM |
| using a vlookup to enter text into rows beneath the vlookup cell | Roger on Excel | Excel Programming | 1 | November 29th 07 12:09 PM |
| Vlookup in vlookup - taking the result as array name | SupperDuck | Excel Worksheet Functions | 2 | June 2nd 07 11:05 AM |
| Which is faster: VLOOKUP-worksheet or VB-array VLOOKUP? | erikhs[_20_] | Excel Programming | 1 | August 6th 06 06:18 PM |
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | MikeR-Oz | New Users to Excel | 1 | March 22nd 06 09:01 AM |
Linear Mode
