Array constants in a nested VLOOKUP

Hello there... I have a VLOOKUP formula that needs to have a nested VLOOKUP in it using an array constant. The issue is the nested VLOOKUP needs to return a name range so that the main VLOOKUP can use that name range to complete the search. Here is the nested formal by it self =VLOOKUP(H19,DesOne,2,0) and here is the nested =VLOOKUP(G18,VLOOKUP(G18,TestTwo,2,0),2,0) The TestTwo is the array and I need it to kick back DesOne like the 1st formula but what is coming back is "DesOne" so the VLOOKUP search will not work cause of the quotes. How do I get rid of the quotes so that it may come back as DesOne to complete the lookup. Hope this makes sense.

Thanks for the reply ..I tried that and I think it is kicking back the same issue. I took some screen shots to show what is going on. The name range is TestSeven cause I have tried many things ha. In the "Excel_1.jpg", you will see the return of the single VLOOKUP showing the columns B:C without quotes, as it should. I left the Formula Builder up as well so you can see what is going on behind the scenes. In "Excel_2.jpg" you can see the same formula now nested in a VLOOKUP and as you can see there is a value error, the last "Excel_3.jpg"
shows what excel is kicking back for the nested VLOOKUP. I highlighted the nested formula and hit F9 to show the result and as you can see it has quotes. The quotes are messing up
the lookup and that is what I am trying to get rid of. I have tried both just an enter after I put in the formula and also a Shift+commamnd+Enter ( being on a mac ) both return the same error. Any feedback would be great!

I got it ! Your indirect worked.. I just needed to get rid of the nested VLOOKUP. Thank for getting me on the right track. All is working the way I would like. Thanks !!!