Sourcing array from cell

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


Not tested, but try: