I am new to VB and have searched for existing answers to this problem but no macros or VLOOKUP commands seem to work. I want to compare date/time in "FINO" sheet column A (in ddmmyy hhmm format) to date/time in "RawScatt" sheet column E (same cell format). Where they match I would like to copy the cells in "RawScatt" columns J and K (numbers) to sheet "FINO" columns I and J.

Thanks for your help!

I'm not sure what problem you are having. I used a basic VLOOKUP and didn't have any problems. With my data starting in Row 1 of both sheets, I used this formula in FINO!I1 and dragged it down to retrieve the data from RawScatt!Column J:

=VLOOKUP($A1,RawScatt!$E$1:$K$18,6,0)

I used this in FINO!J1 to retrieve the data from RawScatt!Column K:

=VLOOKUP($A1,RawScatt!$E$1:$K$18,7,0)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll