Help with Combination of Vlookup, Hlookup and Index's

[Mkammari]

On a userform, I am trying to have a text box automatically populate based on 3 drop down boxes. I am not sure what kind of method would work best and I have not been able to get this to work. Here is my dilema.

Drop down box 1......Ship From Location
Drop Down box 2......Ship to Location
Drop Down box 3......Weight
TxtFreightDollars....(answer I am seeking)


In the text box I am looking for a return value based on a worksheet I have set up for Freight values. The data is set up like this on my worksheet

Ship from Location Range A11:A148
Ship to Location Range B11:B148
Weights Range C10:V10
Freight Dollars Range C11:V148 (This is the value I want returned)

So in summary. I need a freight value returned based on three conditions (Ship From, Ship To, and Weight). The value will automatically populate in a text box. Hope this is all clear.

Michael
[/url]

 

[fairwinds]

Did you confirm the formula with Ctrl + shift + enter insead of just enter?
(Did the curly brackets appear in formula bar as you see in the exhibit?)

 

[Mkammari]

Fair Grounds

I got it to work. Thank you very much for your help. I had to manipulate the data a little but the formula worked to a tee. I know my explanations leave a little to be desired (I'm an accountant, not an IT guy). I want to thank all of you for your help and attempts from the bottom of my heart.