Hello All,

I have been trying for the last day to resolve a code expression I just can't seem to get right. It is to perform a Vlookup to lookup a multiplier for a part based off of its cost to determine it's sell price.

Here are the details:

1. The Cost Each Text Box is identified as "txtSellbyCost"

2. Prior to entering the part it must lookup the value above on the "Tables" Worksheet which is Sheet 4. The Table is three columns with a range of D5:F30 which I have named the Range "Multiplier_Table". If the price falls between the value of column 1 and column 2 it uses column 3 to determine the multiplier.

3. After looking up the correct Multiplier the Value is returned to the user form to the Multiplier Text Box named "txtMultiplier"

Here is the piece of Code I am using to perform the Vlookup Function and no matter how many ways I have tried to express it the return is an error

txtMultiplier.Value = Application.WorksheetFunction.VLookup(txtSellbyCost.Value, Sheet4!("Multiplier_Table"), 3)

Any help to correct the Code above would be greatly appreciated.

Larry