Explore BrainMass
Share

Explore BrainMass

    Vlookup - If I have a dollar amount for my ticket

    This content was COPIED 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 9, 2019, 6:52 pm ad1c9bdddf
    https://brainmass.com/computer-science/data/vlookup-if-i-have-a-dollar-amount-for-my-ticket-100859

    Attachments

    Solution Summary

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

    $2.19