If formula and Data Validation parallely

[PRITESH PARMAR]

Hi,

How to use If and Data Validation Formula
ex. i have customer list of 1000 and each customer has 3-4 different addresses. so if i choose customer "CUST01" at cell a1 then only 3 addresses related customer "CA01", "CA02","CA03" should reflect on data validation of cell a2.

Pritesh.

 

[Becky]

Welcome to the forum Pritesh I'm not sure I understand what you are asking - where does the IF function come in to it?

If all your data (customer names and addresses) is in a table then it sounds like a Filter would actually do what you're looking for - highlight the top row of the table (where the column descriptions are) and select Filter from the data tab. You can then select the customer from a drop-down list and it will bring up corresponding addresses.