SOLVED
Home

Need help creating a formula in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-662760%22%20slang%3D%22en-US%22%3ENeed%20help%20creating%20a%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-662760%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116862i5DE97EB53B48D727%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Formula%20Help.JPG%22%20title%3D%22Formula%20Help.JPG%22%20%2F%3E%3C%2FSPAN%3EI%20need%20help%20creating%20a%20formula%20at%20incorporates%20the%20info%20in%20the%20list%20below%20the%20main%20table%20in%20the%20image%20above.%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-662760%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-662841%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20creating%20a%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-662841%22%20slang%3D%22en-US%22%3EYou%20may%20use%20this%20formula%20in%20H4%3A%3CBR%20%2F%3E%3DIF(B4%3D%E2%80%9CEmpty%E2%80%9D%2CO%244%2C%3CBR%20%2F%3EIF(B4%3D%E2%80%9CLoaded%E2%80%9D%2C%20LOOKUP(F4%2CM%248%3AM%2412%2CO%248%3AO%2412)%2C%3CBR%20%2F%3E%E2%80%9C%E2%80%9D))%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-663297%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20creating%20a%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-663297%22%20slang%3D%22en-US%22%3EThanks%20that%20worked%20perfectly%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-663381%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20creating%20a%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-663381%22%20slang%3D%22en-US%22%3EIt%20pleases%20me%20to%20know%20that!%3C%2FLINGO-BODY%3E
JoeJr382018
New Contributor

Formula Help.JPGI need help creating a formula at incorporates the info in the list below the main table in the image above. Thanks

3 Replies
Solution
You may use this formula in H4:
=IF(B4=“Empty”,O$4,
IF(B4=“Loaded”, LOOKUP(F4,M$8:M$12,O$8:O$12),
“”))
Thanks that worked perfectly
It pleases me to know that!
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies