Sourcing array from cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1282542%22%20slang%3D%22en-US%22%3ESourcing%20array%20from%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1282542%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20cell%20c4%20which%20holds%20the%20name%20of%20the%20array%20that%20i%20am%20trying%20to%20use%20in%20a%20vlookup.%26nbsp%3B%20My%20formula%3A%20%3Dvlookup(%24b7%2Cc4%2C3%2Cfalse)%20is%20returning%20%23N%2FA.%26nbsp%3B%20If%20I%20retype%20the%20formula%20as%20%3Dvlookup(%24b7%2CDailyClose%2C3%2Cfalse)%26nbsp%3B%20it%20works%20just%20fine.%26nbsp%3B%20Content%20of%20c4%20is%20DailyClose.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1282542%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1282551%22%20slang%3D%22en-US%22%3ERe%3A%20Sourcing%20array%20from%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1282551%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F609949%22%20target%3D%22_blank%22%3E%40mryno%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20tested%2C%20but%20try%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DVLOOKUP(%24B7%2CINDIRECT(C4)%2C3%2Cfalse)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a cell c4 which holds the name of the array that i am trying to use in a vlookup.  My formula: =vlookup($b7,c4,3,false) is returning #N/A.  If I retype the formula as =vlookup($b7,DailyClose,3,false)  it works just fine.  Content of c4 is DailyClose.

 

Thank you for your help!

1 Reply

@mryno 

Not tested, but try:

=VLOOKUP($B7,INDIRECT(C4),3,false)