PDA

View Full Version : depended drop down



capofarukgb
2018-12-03, 05:12 PM
so I'm trying to do a quotation based on depended drop down
I have two colums 1 description 2 price
trying to achieve is
when I select number 1 colum I want number 2 to be automatically displayed
can any one help ? https://uploads.tapatalk-cdn.com/20181203/906a9a273155426851f90db28c2f2507.jpg

Sent from my SM-N950F using Tapatalk

NBVC
2018-12-03, 06:53 PM
I think you are looking for a Vlookup...

I am assuming that you have the descriptions and respective prices in your Price List sheet?

If so, then try something like:

=IF(A17="","",Vlookup(A17,'Price List'!A:B,2,0))

where your price list is in columns A-B of "Price List" sheet,

Then you can copy formula down.

capofarukgb
2018-12-03, 09:15 PM
I think you are looking for a Vlookup...

I am assuming that you have the descriptions and respective prices in your Price List sheet?

If so, then try something like:

=IF(A17="","",Vlookup(A17,'Price List'!A:B,2,0))

where your price list is in columns A-B of "Price List" sheet,

Then you can copy formula down.you are absolute legend that worked thanks

Sent from my SM-N950F using Tapatalk