Forum Discussion
Need Help with Excel formula
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 h...
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,"")