VBA use Application.VLookup and Application.HLookup together

Hi everyone,

I have a table with multiple numbers on the left-hand side column and String value on the first row as headers.

I get one number from a different spreadsheet and then I match that with the numbers on the left-hand side using vlookup. Then I need to use some matching function (such as HLookup) to find the column with the right header from which to pick the right output for the vlookup. At the moment the code looks like this:

Worksheets(List).Cells(i,Col1) = Application.HLookup("CLOSE", Worksheets(Plan).Range("A1:B50"), Application.VLookup(Worksheets(List).Cells(i, col2).Value, Worksheets(Plan).Range(Plan_1 & "2:" & Plan_2 & "200"), value, False), False)

For some reason, the code is not outputting anything, nor is it crashing. Any ideas? thanks