Vlookup 2007

Vlookup 2003

Click on the above to download an example of Vlookup or the running of a macro which uses the SelectCase.

The vlookup applies a search for a matching value or amount and then returns a mapped value to the found value or amount.

The macro shows the use of the SelectCase function.

Rather than using IF statements, the SelectCase function can be applied easily in a VBA form to determine the discounting.

This free download template was built to attempt to apply a value to a range of input values.