Quote:
Originally Posted by Spencer101
Not a problem. I'm here to help :)
In the mean time, perhaps try the below formula for one way to do it.
=VLOOKUP(H2,CHOOSE({1,2},'[2012 Expenses.xlsx]Jan 12'!$c$2:$C$123,'[2012 Expenses.xlsx]Jan 12'!$A$2:$A$1231),2,FALSE)
or
=INDEX('[2012 Expenses.xlsx]Jan 12'!$A$2:$A$1231,MATCH(H2,'[2012 Expenses.xlsx]Jan 12'!$c$2:$C$123,0))
Obviously without sample workbooks I'm unable to properly test these formulas, but the idea is there and they should work.
|
Hi Spencer. Your formula =INDEX('[2012 Expenses.xlsx]Jan 12'!$A$2:$A$1231,MATCH(H2,'[2012 Expenses.xlsx]Jan 12'!$c$2:$C$123,0)) worked like a charm. Needless to say it required some manipulation to get everying in one sheet, but it works perfectly. Thanks!