Forum Discussion

AmieH2245's avatar
AmieH2245
Copper Contributor
Jun 08, 2021
Solved

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! ...
  • Detlef_Lewin's avatar
    Jun 08, 2021

    AmieH2245 

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

Resources