Forum Discussion
Solved
Data Validation to Auto-Populate Adjacent Cell
Good afternoon! I'm very new to using formulas and data validation in Excel, so I apologize if this question has been answered already and I didn't catch it. I'd like to see how to use Data V...
Hi abrewer1
What I understood from your post is that you need corresponding data upon inputting Account Number. You may achieve this by using Index & Match function.
Sample file is attached, please let me know if this works for you or otherwise.
Tauqeer
HIi DianeDennis
Both formulas are the same and will produce the same result.
The only difference is that we usually wrap any formula with IFERROR() to handle errors in the formulas. IFERROR() returns a value that we specify if a formula evaluates to an error; otherwise, it returns the result of the formula.
In our example, if we do not wrap the first formula with IFERROR() it may give #N/A.
IFERROR() gives us the option to replace #N/A or other types of errors with 0, space, blanks or any value that we may think is suitable.
Thanks
Tauqeer
