Forum Discussion
AmieH2245
Jun 08, 2021Copper Contributor
Need Help with a Formula
In the attached file, I need a formula for auto-filling column D. It should be filled based on the corresponding email from each of the two tables. I filled in the top row as an example. Thanks!
=XLOOKUP([@Email],Table5[Email],Table5[Desk Number])
2 Replies
Sort By
- Detlef_LewinSilver Contributor
=XLOOKUP([@Email],Table5[Email],Table5[Desk Number])
- AmieH2245Copper ContributorThank you so much, this is exactly what I needed!