depended drop down

capofarukgb

New member
Joined
Dec 3, 2018
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2010
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 ?
906a9a273155426851f90db28c2f2507.jpg


Sent from my SM-N950F using Tapatalk
 
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.
 
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
 
Back
Top