Forum Discussion
Solved
Auto-populate B1 with data from another sheet based on pull down selected for A1
I have set up one cell, say A1, with a pull down to select the first day of a calendar week. I would like B1 to automatically populate with the applicable week # that corresponds to that which I ...
In B1:
=IFERROR(INDEX(Sheet2!B:B,MATCH(A1,Sheet2!C:C,0)),"")
If you have Microsoft 365, you can also use
=XLOOKUP(A1,Sheet2!C:C,Sheet2!B:B,"")
In B1:
=IFERROR(INDEX(Sheet2!B:B,MATCH(A1,Sheet2!C:C,0)),"")
If you have Microsoft 365, you can also use
=XLOOKUP(A1,Sheet2!C:C,Sheet2!B:B,"")
- XLOOKUP worked perfect, thanks for the quick response!
