Can I use vlookup to choose what forumula to use in a cell?

djrobst · #16 11-03-2015, 03:42 AM

thanks, i just worked this out what I done wrong about a minute before got the subscription email telling me you replied. thanks for all your help

the formula that seems to work i settled with is

Quote:

=VLOOKUP(P2,INDIRECT("'[2015 Cordell Valuation Lookup Tables.xlsx]"&BK2&"'!$A:$I"),5,FALSE)

I realised that the indirect wasnt closed properly.

I'm still wondering what part the & sign plays on the BK2 reference. I've never seen it before? what does that do when I use it? or is it something purely for indirect?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Would like to return a row rather than a cell using VLookup	canajun	Excel	7	12-10-2014 01:03 PM
VLOOKUP looking at another cell for its range	Rich18144	Excel	1	06-24-2014 07:56 AM
trying to use vlookup to calculate several different situations in one cell	heastlund	Excel	3	11-21-2013 12:38 PM
Choose your footer?	KenZu	Word	9	03-08-2012 01:40 AM
need help with a forumula	bigbosky32	Excel	1	11-07-2008 03:15 PM