Map data into one worksheet from another based on criteria

[sas]

Hi Excel Ninja's,

I have a bit of a pickle - the example is the attached spreadsheet.

I have worksheet 1 which has data for certain date/times which are sporadic throughout a 24 hr period - as in there may only be data for 6+- hours on any one day.

I need to extrapolate this data into worksheet 2 which has the entire 24 hr period, ensuring the data appears in the cell with the matching date/time. So date/time is the matching criteria and if there is no match then there should be N/A or blank.

I think this is a little more tricky than Index Match or VLOOKUP as I couldn't get them to work for me.

Any help would be much appreciated!

Cheers
Sas

 

[Nebu]

Hi:

I am not sure why you say Index formula won't work it worked for me perfectly well. Find the attached.

Thanks

 

[sas]

Hi:

I am not sure why you say Index formula won't work it worked for me perfectly well. Find the attached.

Thanks

Thanks Nebu,

After looking at your solution I can't figure out why the Index formula didn't work for me either??

This is perfect, appreciate your assistance.