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 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 September 19, 2018, 12:40 pm ad1c9bdddf - https://brainmass.com/computer-science/data/vlookup-if-i-have-a-dollar-amount-for-my-ticket-100859


Solution Summary

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