Jun 01 2023 07:08 AM
Hello
I have two Tabs that I am trying to make them update automatically once one (the master tab is updated). For example, here is how the master list look like with the data.
and here is the tab 1 that I want to update.
On this tab 1 I want column E to be equal to column L on the master tab if column A and C from tab 1 equal column A and C from the master tab. Meaning when updating column L on the master tab it will automatically update the second tab. What formula do you suggest me to use based on the criteria?
Thank You
Jun 01 2023 08:45 AM - edited Jun 01 2023 08:49 AM
you can use lookup or index(match()) functions and if you have excel 365 then I recommend XLOOKUP. I also recommend you make the tables format as table so you can refer to it as such. (Home->Format as Table and then click the Table tab and name the table something meaningful but I will use Table1 for this example)
=XLOOKUP( [@ID]&[@Program], Table1[ID] & Table1[Program], Table1[% of hours],"")
if you can't create tables then you can use references like
=XLOOKUP( A2&C2, Sheet1!$A$2:$A$200 & Sheet1!$C$2:$C$200, Sheet1!$L$2:$L$200,"")