Jun 08 2021 10:47 AM
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 11:05 AM
Solution=XLOOKUP([@Email],Table5[Email],Table5[Desk Number])
Jun 08 2021 11:14 AM
Jun 08 2021 11:05 AM
Solution