Need Help with a Formula

New Contributor

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!

2 Replies
best response confirmed by allyreckerman (Microsoft)


=XLOOKUP([@Email],Table5[Email],Table5[Desk Number])
Thank you so much, this is exactly what I needed!