depended drop down [Archive]

capofarukgb

2018-12-03, 06: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, 07: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, 10: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