Lookup one value from list with another value in same list

%3CLINGO-SUB%20id%3D%22lingo-sub-2595770%22%20slang%3D%22en-US%22%3ELookup%20one%20value%20from%20list%20with%20another%20value%20in%20same%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2595770%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anybody%20know%20if%20it%20is%20possible%20to%20lookup%20a%20value%20based%20on%20a%20other%20value%20in%20the%20same%20list%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eeg.%20LOOKUP%20Key%20against%20Key2%20and%20return%20Day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESharePoint%20List%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hk456_0-1627609347327.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F299445i9F0C7A1AE626AD68%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hk456_0-1627609347327.png%22%20alt%3D%22hk456_0-1627609347327.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2595770%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

 

Does anybody know if it is possible to lookup a value based on a other value in the same list?

 

eg. LOOKUP Key against Key2 and return Day.

 

SharePoint List

hk456_0-1627609347327.png

 

Thank you 

 

0 Replies