Vlookuping in different column according to time

[ylijohe]

I am making a program to compare stock prices. Unfortunately the free stock price server changes to position of the last prices when the market closes. When the market is open, I should vlookup column 2, but after closing time (8 pm or 20:00), Ishould vlookup column 4.

Any ideas how to solve this?
How to implement time checking to this formula:
VLOOKUP(A9;(VALUES!A$1:D$278);2;FALSE))

 

[ylijohe]

I got error: TYPE MISMATCH when I try to use formulas that you have suggested....

I try to solve the problem by reading both colums 2 and 4 and then check if column 2 contain only "0":s, and if so, use column 4, which is then active. This way I don´t have to check the time at all.

Thank you all, we almost did it!