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! ...
- Jun 08, 2021
=XLOOKUP([@Email],Table5[Email],Table5[Desk Number])
Detlef_Lewin
Jun 08, 2021Silver Contributor
=XLOOKUP([@Email],Table5[Email],Table5[Desk Number])
- AmieH2245Jun 08, 2021Copper ContributorThank you so much, this is exactly what I needed!