How to Autofill one sheet based on a table made in another sheet.
Hello, I am struggling to find the right formula that will let me fill Sheet 2 Column B based on the value in Column A. In the reference table made in another sheet I have all possible Column A values and the Column B values that match. What is the best formula to use. It will need to see that the A column cell matches the A column cell in the other sheet and then fill the corresponding B,C,D and E column values. But just filling column B is most important. Thank you for any help. I know EXCEL is very powerful and has the ability to do stuff like this. Until then I am copy/pasting values across which when some tables have 45 rows and there's 60 tables is a huge waste of time. Sheet 2 Reference Table
Need to search multiple words in a cell and get the output based on the word found.
Hi, I am having a data in column A like below, then I need search for multiple words like "Generic Mailbox", "Distribution", "Non-standard", "NSSR" in the each cell and then if "Generic mailbox" is founds in the cell, output should be "shared mailbox" or If "Distribution" is founds in the cell, output should be "DL" or If "Non-standard" is founds in the cell, output should be "Corporate request" or If "NSSR" is founds in the cell, output should be "Non-Standard Service request" Looking for to get help on this!! Thank you.
Excel Script - Refresh data
Hi, I have an excel file which has a data connection. I have been trying to get the data and associated pivot tables to refresh through a script but it doesn't seem to work fully. The script is as follows: function main(workbook: ExcelScript.Workbook) { // Refresh all data connections workbook.refreshAllDataConnections(); workbook.refreshAllPivotTables } I am prompting the script to run through PowerAutomate a couple of times a day. The file will appear to be modified (last modified date of file reflects when the script was last run through PowerAutomate) but the data in the Pivot table is not up to date from the data source. If I open the file online will get a message to enable the queries so I don't know if this needs to be part of the script too? Any thoughts? Thanks
2013 doesn't have =filter() function. ANY alternate function?
I have Microsoft excel 365 in that filter function is available and i create a follow up sheet linked with database sheet where in database user will store data from the form. In database there is a column Follow up date. I want to show the all the data which will meet a date condition. I have done by using filter function but in 2013 it doesn't have filter function what function can i use to perform the same operation?
