Mar 30 2020 03:35 PM
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.
Mar 30 2020 03:59 PM
Mar 31 2020 03:45 PM
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.
Apr 01 2020 06:45 AM - edited Apr 01 2020 06:45 AM
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.