•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to autopopulate according to certain values
Our take
Are you struggling with how to autopopulate values in your spreadsheet based on specific criteria? You’re not alone—many find this task daunting. Fortunately, using a straightforward formula can streamline your data entry process. By employing the IF function in Excel or Google Sheets, you can easily assign values like A, B, or C based on your defined criteria. For example, if your value is 2234, the formula will automatically input B for you.
hi i need help 🙏🏼 which formula to use for below
if Value is 1112, 1212, 1312, 1412 then its A
if Value is 2134, 2234, 2334, 2434 then its B
if Value is 3156, 3256, 3356, 3456 then its C
so lets say that the value is 2234, i want the formula to input as B
if the value is 1112, the formula will input as A
[link] [comments]
Read on the original site
Open the publisher's page for the full experience