depended drop down

[capofarukgb]

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 ?

Sent from my SM-N950F using Tapatalk

[NBVC]

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]

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