Add missing value into cell when criteria are met

letchimera

New Member
Joined
Jan 13, 2018
Messages
3
Hi All,

I have a sheet with data and comments added to it. However, this data is changing and new reports need to be run. However, the comment field is the same for the old data.
So i would like find and insert the value in the cells from "Comment" column into the new spreadsheet, as per below:


Old spreadsheet:
DateTimeTagNameStateComment
13/01/201805:08:58OperationsStefanONIn spain has rain again
12/01/201807:08:17BankingDeidraONDoor was opened
04/01/201816:15:27ConsultMikeONDoor was closed

<tbody>
</tbody>

New spreadsheet, where data is missing:

DateTimeTagNameStateComment
13/01/201805:08:58OperationsStefanON
12/01/201807:08:17BankingDeidraON
04/01/201816:15:27ConsultMikeON

<tbody>
</tbody>

The Date, Time and Tag need to be the Unique Identifier. I was thinking something like IF(A2,B2,C2 found in '1201'! Then insert F"value" in '1301'! Fx)
Any help Is greatly appreciated.

Regards,
Stefan
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

krogh101

New Member
Joined
Jun 29, 2015
Messages
17
Hi Stefan!

If you are able to add a helper-column to the old spreadsheet, you could use a simple VLOOKUP or INDEX MATCH?

The helper-column would be something like =Date&Time&Tag and the VLOOKUP would be =VLOOKUP(Date&Time&Tag,[OldSpreadsheet]Book1!$A$2:$G$4,7,0)
(This is based on if the old data is in another workbook, with the helper-column in column A. And the new data is set up from column A1, and the formula in the comment column.)

br.
Henrik
 

letchimera

New Member
Joined
Jan 13, 2018
Messages
3
Hi Henrik!

Thank you for the help here!

I let you know if I succeed in setting that up.

KR.
Stefan
Hi Stefan!

If you are able to add a helper-column to the old spreadsheet, you could use a simple VLOOKUP or INDEX MATCH?

The helper-column would be something like =Date&Time&Tag and the VLOOKUP would be =VLOOKUP(Date&Time&Tag,[OldSpreadsheet]Book1!$A$2:$G$4,7,0)
(This is based on if the old data is in another workbook, with the helper-column in column A. And the new data is set up from column A1, and the formula in the comment column.)

br.
Henrik
 

krogh101

New Member
Joined
Jun 29, 2015
Messages
17
Stefan,

Would you be willing to share the workbook(s)? Then I'll happily take a look at it.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,504
Messages
5,602,060
Members
414,498
Latest member
jordanmiller7890

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top