Time missing in columns

I have two data files. In one the time is showing in the column "Time". In the other file, the column "Time" is there but there is no time shown. When the transfer from one system to the other took place, the time did not advance to the other data file.


What I need to do, is that, if the Incident # in column "A" matches the Incident # in column "H", then the time shown in column "E" will be placed in column "L".

I am using Windows 10, Excel 2016

Thank you

you can make use of the IF() function on the sheet. you can combine that with VLOOKUP, or you might not even need to look up anything. just a cell reference might suffice. what do you mean by this?

When the transfer from one system to the other took place, the time did not advance to the other data file.


are you transferring data from a server program to a local excel file? if the time is being lost, there are probably a million reasons for that. if that's not what you're doing, maybe the cell is not formatted correctly?

I believe that the time cell was accidently deleted, the best I can tell. Now I have to replace it back in the new transferred file. Both files are on my system.

The IF function would work if all Incident Numbers are in correct order and none are missing. However, I have found Incident # that are not on some data fields. So, the IF functions does work for some, but not all rows.

However, I have found Incident # that are not on some data fields. So, the IF functions does work for some, but not all rows.

well, if that's the case, you can also use the ISERROR() function do to something else if an incident number is missing, don't you think? as far as data not being in the correct ""order"", that really doesn't matter. the autofill handle can do some of that work for you when the data [is] in order. and code it also available too (and probably other methods that the pros know about), if you want to loop ranges and put a formula in cells then recalculate the worksheet. for instance, in code I think you can put something like this in any given cell:

Please Login or Register  to view this content.

you might also have to use the alternative though:

Please Login or Register  to view this content.

I am not familiar with the formulas you mentioned. I am just learning more each day. I will try to research on google. Thanks

good deal. every function, described my microsoft, can be returned as a first return on the list by google if you run the following search as a web address:

https://www.google.com/search?q=exce...rosoft+support

the address for the above link, since it doesn't show all of it, is:

https:// www. google.com/ search? q=excel+FUNCTION_NAME_HERE +function+microsoft+ support

obviously, put the name of the function you want to look at in place of the ""FUNCTION_NAME_HERE"" text.

It worked beautifully. Thank you very much !