Quote:
Originally Posted by GijsKijlstra
Thank you Spencer, for your fast response. Regrettably it didn't work.
For the WAGES (h2 in 2013 Expenses), its lookup reference WAGES is in column C (in [2012 Expenses.xlsx]Jan 12') and the value I wish to return (in k2 in 2013 Expenses) is to be found in column A of [2012 Expenses.xlsx]Jan 12'.
|
Ok. VLOOKUP doesn't work where the value to be returned is in a column before the one with the reference in. You can use a combination of VLOOKUP and CHOOSE to accomplish this, or INDEX and MATCH.
Without seeing example workbooks it's difficult to provide you with an exact formula. If you need more help, feel free to email example workbooks to me on pubnut @ gmail . com (without spaces, obviously).