SOLVED

Need Help with a Formula

Copper 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)
Solution

@AmieH2245 

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

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@AmieH2245 

=XLOOKUP([@Email],Table5[Email],Table5[Desk Number])

View solution in original post