•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
IFS formula that changes constantly
Our take
If you're seeking a dynamic solution for your IFS formula, you've come to the right place. The goal is to create a formula that aligns values based on changing names in your spreadsheet. Specifically, if the name in A1 matches the name in B1, you want C1 to reflect a corresponding value from G1. Given the daily fluctuations in names due to arrivals and PTO, a well-structured formula can streamline this process.
Hello! I’m looking for a formula that basically goes if A1 matches B1 based on a persons name, then C1 will correlate a value listed in G1. The problem I’m running into is that the names change everyday based on arrival/pto. Please let me know what is the best solution!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#cloud-based spreadsheet applications#Excel alternatives for data analysis#AI formula generation techniques#rows.com#formula generator#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#IFS formula#Excel#correlate#value#A1#B1#C1#G1#names#arrival#pto