I am working on a spreadsheet for company benefits. Depending on whether a person has benefits only for themselves, a child or spouse etc it will be a certain value. So in column B I'm writing the coverage description and based on that I want column D and E to auto input the amount that goes with the Column b description. How can I write this formula if it's even possible. Thank you
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
If all of column B says then D and E need to say
0
Answers
0
Hi K and welcome to the Forum.
It should be fairly easy to do that using Excel's IF (worksheet) function. In the Excel Tutorials section, Don has provided a few tutorials on this; try IF() Statement Function in Excel - How to use it and 15 IF Statement Examples in Excel (but there are others).
If your needs are more than covered there, you might need to use the IFS function or others. If so, please edit your original question to decribe the need more fully and use the Add Files... button to upload a representative Excel file (without any personal data) to show your existing macro and data. Then we should be able to give specific help.
Hope this helps.
Discussion
Hello K,
Another possibility is Excel's vlookup function. But as John has mentioned, a sample file that shows what you are trying to do will make it easier to provide a solution(s) for you.
Another possibility is Excel's vlookup function. But as John has mentioned, a sample file that shows what you are trying to do will make it easier to provide a solution(s) for you.
WillieD24 (rep: 557) May 22, '22 at 10:37 am