Explore BrainMass

Vlookup - If I have a dollar amount for my ticket

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

I'm trying to setup a vlookup.

Basically, if I have a dollar amount for my ticket ie: $5012 and I'm going to location 3, I want it to call on the table in the second tab, and pull data from cell E5 (and tell me the premium)... and so on for the other numbers.

The dollar amount is to be in a range, the location is an exact number.

© BrainMass Inc. brainmass.com October 24, 2018, 8:34 pm ad1c9bdddf


Solution Summary

The solution provides detailed instructions and discussion on how to use the VLOOKUP function.

See Also This Related BrainMass Solution

Human Resource Management: Employee Benefits

Employee Benefits

I need to create a draft and post a memo to upper management detailing the benefits available to employees in the positions of accounts receivable clerk and financial controller.

I must include include health insurance, time off, retirement/savings plan, and one other work/life benefit.

I must explain to management the primary strategic consideration involved in managing the proposed benefits program.

I need to identify an additional strategic consideration related specifically to one of the benefits in your proposed program.

Must be 500 + words in length.

I would like to include in the paper.......

Health insurance, time off, retirement/savings plan, and one other work/life benefit.

Explanation of the primary strategic concern.

Explanation of an additional strategic consideration.

The content is comprehensive, accurate, and /or persuasive.

The paper develops a central theme or idea, directed toward the appropriate audience.

The focus of the paper is on the components of the benefits plan for the position chosen for the final project.

The strategic considerations are clearly related to the benefits discussed.

The paper is in memo form and appropriate for delivery to upper management.

Major points are stated clearly; are supported by specific details, examples, or analysis; and are organized logically.

Each type of benefit is elaborated on.

The primary strategic consideration is identified as cost.

Additional consideration is explained and related to one of the plan benefits

The introduction provides sufficient background on the topic and previews major points.

The purpose of the memo is introduced at the beginning of the paper.

The conclusion is logical, flows from the body of the paper, and reviews the major points.

View Full Posting Details