Forum Discussion
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 ...
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.
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.