Excel : Vlookup

[Dolby]

I haven't touched this stuff in years - but I'm sure I did it similar years back with a Vlookup

Basically I have a brand with phones and PBXs. I need to make it as easy as possible for the sales guys to quote - so I'm thinking simply put in the extension and it spits out a model number / other specs

Line A 9-12 are models ; Line B9-12 are the UP TO lines. How can I make it automatically pull up a model based on what they enter in B1?

Same with the phones really - they enter how many basic they want, and it spits out the specs. I'm thinking of adding drop down boxes to make it more granular ie (colour / LCD) etc - but I think I can work it out from the formula from the PBX model

 

[gfmalan]

Can't do it easily with Vlookups, I have other way for you, when you selt items from drop down lists, it only give you matching options in second drop down.

I'll populate a sheet and mail it to you in the morning, unless someone else help you first

 

[Mars]

How would you qualify the number in B1?

You would need some logic there to find out what the best match would be. So its easy to see that you would need PBX Model 2 because it matches the correct amount of extensions, but what if you have more than one basic model of phone? Would you want a drop down showing the different basic phones?

Then it would be easier just having all the phones in their own sheet with a table for each kind of phone range. The same for the PBX's I suppose. You could filter the results of the drop down based on the criteria of the value in the B column. Something like this: https://www.mrexcel.com/forum/excel-questions/546177-vlookup-find-next.html#post2696961

In cases where you have a range you would resolve that to a single value first in another cell ie: =CEILING(B1,10) to round up to the nearest 10.

 

[Dolby]

My Excel skills are shot ...

Just looking at the easiest way actually.

I guess adding a drop down box as a filter is more complex?

 

[Dolby]

Can't do it easily with Vlookups, I have other way for you, when you selt items from drop down lists, it only give you matching options in second drop down

Anything will be helpful, thanks!

At least I'll have a basis to learn from