vlookup Tractors

[bianchipassione]

I want to create page using a filters data as it proceeds. the end result is a means for our salesmen to find the purchase price of different models of tractors.

Ideally, the person will select the brand of tractor, then using the next box, select the particular make. (up to 30). After selecting the make, they would then select from up to 5 models. Once done, the purchase information would be displayed.

I have a page containing all the information from which the vlookup will use.

Right now, I am getting #NA as a result.

My vlookup uses the entered brand name the user would type in. the formula is: =VLOOKUP(B1,CombPurchModel!A2:X$112,2,0)

 

[JonXL]

I have created your desired functionality - inside a userform.

Are you open to using this as an option? The code I created currently does not return the extra values corresponding to the chosen brand, model, etc., but I can add that easily if you are okay with this option and present you with all the code, etc.

The userform can be called straight from the sheet your users are working on when they click a row, cell, etc. and then update the values as needed; or it can just return the information if your users are only using the lookups to get information (for example, to give to customers).

Let me know

 

[Aladin Akyurek]

Essentially, once the user "drills" down and selects the correct tractor, he will see the purchase amount, rental rates as well as help determine the selling price. (my list above does not display at least 8 columns of data)

Care to post an example output that is computed manually according to the description you provide above?