Data Validation - If function drop down

shiraz50

New Member
Joined
Jan 16, 2023
Messages
31
Office Version
  1. 365
Platform
  1. Windows
Hi Team

I need some help

In sheet 2 i have data setup that shows the country and addresses. Some addresses are in the same country .

I want to add a data valuation formula in Sheet 1 Column I to state if i choose country in Sheet 2 column A then data from Sheet 2 column C must be populated in Sheet 1 Column I .

Please can you help .

1725617316108.png
1725617330150.png
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Hi @shiraz50

I need a little clarification. Your question is a little confusing to me.
I want to add a data valuation formula in Sheet 1 Column I to state if i choose country in Sheet 2 column A
What does "if I choose" mean in "if I choose country in Sheet 2 Column A"?
Data validation works on single cells (values) not on columns or rows.

data valuation formula in Sheet 1 Column I to state if i choose country in Sheet 2 column A then data from Sheet 2 column C must be populated in Sheet 1 Column I .
That seems to be a circular reference if I've got it right. You choose from Sheet 2 Column A, but at the same time your data IS in Column A

Maybe you need something like this:
Easy Steps Excel Dependent Drop Down List Data Validation
or this:
Data validation with conditional list

But if I got you right, you'll need conditional data validation with some lookup function.

Please taka a look at those two topics and tell me if that's close to what you're looking for.
If possible, could you please give another example of your data validation.
 
Upvote 0
Solution
Hi Pete

Yes i think the conditional formatting will work but how do i create this formula in one cell on sheet 1 (Column I )

So if the country is selected in Sheet 2 (Column A) then data from Sheet 2 ( Column C ) must be avaialble as a drop down function in Sheet A (Column I )

I hope this clarifies ? Thanks for your support. Please let me know.
 
Upvote 0
Hi @shiraz50
I'm still confused.

First, selecting a cell or range of cells in one sheet does not affect other sheets, so you can't add an action or formula unless you save your file as "Macro-enabled workbook" (*.xlsm) and use some VBA code that performs some actions depending on a selection.

What you can do is add a dropdown list that changes depending on what you enter in a cell.

What do you mean by "selecting" in "country is selected in Sheet 2 (Column A)"?

Please help me understand.
 
Upvote 0
Hi Pete

I will go with the first option. It seems to have worked. Thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top