Can you Reverser engineer a formula to lookup a data in a another cell in the row

%3CLINGO-SUB%20id%3D%22lingo-sub-1784242%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20you%20Reverser%20engineer%20a%20formula%20to%20lookup%20a%20data%20in%20a%20another%20cell%20in%20the%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1784242%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F829643%22%20target%3D%22_blank%22%3E%40naheemhussainuk%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20please%20submit%20a%20sample%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1783927%22%20slang%3D%22en-US%22%3ECan%20you%20Reverser%20engineer%20a%20formula%20to%20lookup%20a%20data%20in%20a%20another%20cell%20in%20the%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1783927%22%20slang%3D%22en-US%22%3EIve%20have%20table%20with%20three%20colums%3CBR%20%2F%3EName%2C%20price%20for%20usage%20kw%20and%20rent%20per%20day%3CBR%20%2F%3EIve%20calculate%20the%20unit%20price%20by%20usage%20and%20rent%20per%20day%20in%20one%20cell%20but%20id%20like%20to%20reverse%20engineer%20the%20formula%20to%20lookup%20the%20name%20in%20the%20another%20column%20in%20the%20row.%20Please%20help%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1783927%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
New Contributor
Ive have table with three colums
Name, price for usage kw and rent per day
Ive calculate the unit price by usage and rent per day in one cell but id like to reverse engineer the formula to lookup the name in the another column in the row. Please help
1 Reply