Quote:
Originally Posted by Spencer101
You need to change the 1 at the end of the formula. So if your lookup reference is in column A and the value you wish to return is in column C then your formula should end ,3,false)
Let me know if you need more help.
|
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'.
Similar Threads
Threaded Mode
