Share
Explore BrainMass

Vlookup - If I have a dollar amount for my ticket

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.

Attachments

Solution Summary

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

$2.19