Display data based on Dropdown value

[ilobang]

Hi,

I want the data in Cell to display based on the value in dropdown list.

For Example:

Excel Function (Dropdown).JPG


In Select Country, It is a dropdown with List [US, Canada, Australia, NZ, UK]


If Select Country = US, then Shipping Cost = 1.58
If Select Country = Canada, then Shipping Cost = 4.21
If Select Country = Australia, then Shipping Cost = 4.21
and so on


I don't think Nested If Else is very practical. Is there a SWITCH function in excel?
Please advise..

Below is a link to my Google Excel spreadsheet.
The Cell that needed the function is Spreadsheet "Cat Kingdom" Column D.

https://docs.google.com/spreadsheets...it?usp=sharing

[Logit]

Is this for Google Spreadsheets or for Excel ?

[ilobang]

It's Google.

But what's the difference? They still use the same Excel Formula/Function.

[ilobang]

If you want the MS Excel form, please see attached.

[shukla.ankur281190]

Try

D2

Please Login or Register  to view this content.

[ilobang]

Wow! Thanks Ankur.

Took me a while to understand your function.
So you use the Product Name as matching condition to link the 2 Spreadsheets together.

It works!