VLOOKUP with multiple criterias

[Eyeson15]

Good morning

I tried few of the suggestions from google but still can't get it done right.

I need to find the value from corresponding date & time.

Here is a pic for easier understanding - Im trying to fill all the cells in column G with the corresponding data from column C

The first example in G1, looks for the value of 3rd Jan 2016, 17:00 which is C1.

second example in G2, looks for the value of 3rd Jan 2016, 17:24 which is C25. I highlighted them to help you understand.

I hope I am explaining this clearly.

Any help will be GREATLY appreciated. - James

 

[Eyeson15]

hi again

i sort of worked it out

{=INDEX(C:C,MATCH(E1&F1,A:A&B:B,0))}

works. this is array formula btw
im interested in a vba option but im grateful to have this at least.