Forum Discussion

77F150XLT's avatar
77F150XLT
Copper Contributor
Mar 30, 2020

Referencing multiple cells based on a single cell input

This is really poor wording, but I'm looking for a way to automatically reference multiple cells based on the input of a single cell. I have two sheets in my excel work book, sheet one will have all the manual entered data, sheet two will be a permanent reference. I want to be able to type a 4 digit "Code" into one cell and have it fill the name, and address of the cells from the second sheet. I have the cell I want to input shown on the sheet 1 with a red arrow, and the cells I want to have automatically input shown with black arrows. sheet two is the cells that contain all the data that I want transferred to the cells in sheet one. Thanks for any help, this should be stupid easy, I'm just drawing a blank. 

Formulas and Functions

3 Replies

    • 77F150XLT's avatar
      77F150XLT
      Copper Contributor
      Mar 31, 2020

      Patrick2788 

      Unfortunately i'm on the semi annual update plan with office 365 so I don't have access to the xlookup function yet. is there another way to do it? Thanks a bunch.

      • Patrick2788's avatar
        Patrick2788
        Silver Contributor
        Apr 01, 2020

        77F150XLT 

        Yes, your base formula (going off my sample workbook) becomes:

        =IFERROR(VLOOKUP($A2,Retailer!$A:$F,COLUMN(B1),0),"")

         

        Fill handle it across and down as needed. Make the column references ($A:$F) specific to your range.

Resources