Thanks! I'll try that first thing in the morning and see if it works. I keep forgetting to put in a today column when I try formulas. That makes things so much easier.
I'm working on pulling our health insurance amounts for all employees. We have two broad types of plans with 11 variables under each. I have a table in another worksheet where I have all the values laid out. I need help with a formula. I have columns on a big spreadsheet showing whether an employee is in HPOS or HRA, then another column showing the numbers 1-5 or 11-16 which signify employee only, employee spouse, etc...
Thanks for any help.
edited post above.
Thanks. I'll try it again but for now it works. It took me about 10 minutes to do data sorts, links, and copy and paste everything. Vlookup was working for the most part but I had a couple of errors in the small departments I was testing so I didn't trust it. I'll try to figure out after my meeting.
Isn't this basic algebra? Just divide your # by 1.02
Glad they're paying you the big bucks to move to Charleston.