Forum Discussion

abrewer1's avatar
abrewer1
Copper Contributor
Aug 16, 2019

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...
data validation
Formulas and Functions
  • tauqeeracma's avatar
    tauqeeracma
    Aug 16, 2019

    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

tauqeeracma's avatar
tauqeeracma
Steel Contributor

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

abrewer1's avatar
abrewer1
Copper Contributor
Aug 16, 2019

tauqeeracma 

 

I really appreciate you following up with me so quickly on this. I've tried your suggestion, but instead of having the content that you have in columns A & B, I've moved it to another sheet within the same workbook. I'm not sure if that is the reason, but I'm getting an #N/A error. The formula I'm using is =INDEX(Sheet2!$B$2:$B$7864,MATCH(J2,Sheet2!$A$2:$A$7864,0))

 

I've attached a new screenshot so you can see the formula and error. 

 

Thanks so much!

  • abrewer1's avatar
    abrewer1
    Copper Contributor
    Aug 16, 2019
    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!!

Resources