Linking Cells From Another Page with Reffering to a Text Hi, I have a workbook t

Question

Linking Cells From Another Page with Reffering to a Text

Hi,

I have a workbook that contains from two sheets. Page 1 looks as the following:   

Page 2 looks like the following:

I want to identify the account number in page 1 referring to the account description. In other words, I have set column B in page 1 "Account Description" as a list through data validation to list the accounts descriptions from Page2 and I want the account number in page 1, cell A2 to be added automatically depending on the account description selected in the cell next to it and referring to the account number in Page2.

I hope that I could explain what is requested here.

Thanks

Explanation / Answer

#%&#&5

If Account Number is in Sheet1's A1 and Account # is in Sheet2's A1 then put this formula in Sheet1's A2,

=IFERROR(INDEX(Sheet2!A:A, MATCH(B2, Sheet2!B:B, 0)), "")

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.