Modify values in main sheet from other file

Question

Hi,

I have 2 sheets.

1 is main sheet and the other is generated through different workflow.

Main sheet has 400 rows and 10-12 columns.

2 key columns are Name and Type.

2nd sheet has modify values.

With Name(Main sheet) Type(Main sheet)  Name(Modify sheet) Type(Modify sheet) columns

Now I need to modify the values in "Type" column of Main sheet based on the Type values in Modify sheet corresponding to same name.

Name(Main sheet) Type(Main sheet)  Name(Modify sheet) Type(Modify sheet)

ABC                            Open to all                   ABC                     Closed to all

XYZ                               [Null]                          XYZ                        Open to all

and so on...

So the type of the name ABC, and XYZ must change to Closed to all, and Open to all in the main sheet with 400 rows, while every other thing remains same.

ShantanuDagar · Answer

Both are in different files. Each file has multiple sheets which are being used in workflow, out of which the said sheets need to be taken for this part.

FinnCharlton · Answer

Hi @ShantanuDagar , are these Excel sheets you're talking about? If they're in the same workbook you can probably write an Excel formula to do this for you, maybe an XLOOKUP?