Need Help with a Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2427942%22%20slang%3D%22en-US%22%3ENeed%20Help%20with%20a%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2427942%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20attached%20file%2C%20I%20need%20a%20formula%20for%20auto-filling%20column%20D.%20It%20should%20be%20filled%20based%20on%20the%20corresponding%20email%20from%20each%20of%20the%20two%20tables.%20I%20filled%20in%20the%20top%20row%20as%20an%20example.%20Thanks!%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2427942%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2428019%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20with%20a%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2428019%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%2C%20this%20is%20exactly%20what%20I%20needed!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2428006%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20with%20a%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2428006%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1073976%22%20target%3D%22_blank%22%3E%40AmieH2245%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DXLOOKUP(%5B%40Email%5D%2CTable5%5BEmail%5D%2CTable5%5BDesk%20Number%5D)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
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

@AmieH2245 

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