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
I figured out the issue! It was because the data in Sheet2 was inserted as "From Text/CSV". I went back and inserted the data in Sheet2 as just a copy/paste and it worked!! You just made my job so much simpler! Thank you!!
abrewer1 You are welcome