Xlookup

%3CLINGO-SUB%20id%3D%22lingo-sub-2419947%22%20slang%3D%22en-US%22%3EXlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2419947%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%20Xlookup%20...%20I%20have%20am%20trying%20to%20add%20figures%20located%20within%20the%20same%20column%20%26nbsp%3B...%20for%20example%20...%20REG%20Hours%2040%20and%20OT%20Hours%206%20on%20the%20row%20underneath%20but%20in%20the%20same%20column%20...%20how%20do%20I%20incorporate%20this%20into%20my%20xlookup%20formula%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2419947%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2420176%22%20slang%3D%22en-US%22%3ERe%3A%20Xlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2420176%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1072206%22%20target%3D%22_blank%22%3E%40Meggaman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20please%20provide%20simple%20sample%20file%20to%20illustrate%20the%20question.%20That's%26nbsp%3B%20unclear%2C%20at%20least%20for%20me%2C%20why%20do%20you%20use%20XLOOKUP()%20not%20any%20other%20function%20and'%2C%20more%20important%2C%20what%20you'd%20like%20to%20calculate.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Using Xlookup ... I have am trying to add figures located within the same column  ... for example ... REG Hours 40 and OT Hours 6 on the row underneath but in the same column ... how do I incorporate this into my xlookup formula?

1 Reply

@Meggaman 

Could you please provide simple sample file to illustrate the question. That's  unclear, at least for me, why do you use XLOOKUP() not any other function and', more important, what you'd like to calculate.