Extracting data across sheets based on variables in sheet 1
Hello all, I am trying to find a way to extract data in column 1, into another sheet to be viewed in a list there, but based on variables in column 3. This is for work so I cant share the actual example, but I have thrown together a simple example to show it in excel. Based on my example attached, I am trying to extract the tasks that are “not done” into the other dashboard sheet to be able to use the sheet as a quick overview without having to go through the table
I have tried to write an XLOOKUP formula to do this but I can’t seem to get it working, any help would be greatly appreciated!!
Hello all, I am trying to find a way to extract data in column 1, into another sheet to be viewed in a list there, but based on variables in column 3. This is for work so I cant share the actual example, but I have thrown together a simple example to show it in excel. Based on my example attached, I am trying to extract the tasks that are “not done” into the other dashboard sheet to be able to use the sheet as a quick overview without having to go through the table I have tried to write an XLOOKUP formula to do this but I can’t seem to get it working, any help would be greatly appreciated!! Read More