Sourcing array from cell

Highlighted
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
Highlighted

@mryno 

Not tested, but try:

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