Home

Pulling my hair out with formula options

%3CLINGO-SUB%20id%3D%22lingo-sub-615571%22%20slang%3D%22en-US%22%3EPulling%20my%20hair%20out%20with%20formula%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615571%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guru%E2%80%99s%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20set%20up%20a%20dashboard%20where%20you%20can%20enter%20a%20error%20number%20in%20A1%20then%20select%20a%20date%20(month)%20from%20a%20drop%20down%20list%20in%20C1%20and%20I%E2%80%99m%20wanting%20it%20to%20find%20the%20data%20for%20the%20date%20selected%20based%20on%20the%20error%20entered%20and%20return%20the%20value%20in%20C2.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESheet%202%20contains%20the%20list%20of%20errors%20in%20A2%2C%26nbsp%3Bthe%20dates%20are%20in%20N2-Z2%20and%20the%20data%20relating%20to%20the%20error%20and%20date%20are%20in%26nbsp%3BN3-Z3%3C%2FP%3E%3CP%3Ethe%20dates%20in%20the%20drop%20down%20are%20identical%20as%20those%20in%20Sheet%202%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eim%20going%20crazy%20on%20how%20this%20can%20be%20achieved%20if%20at%20all%3C%2FP%3E%3CP%3Ethank%20you%20in%20advance%20of%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-615571%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-615630%22%20slang%3D%22en-US%22%3ERe%3A%20Pulling%20my%20hair%20out%20with%20formula%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615630%22%20slang%3D%22en-US%22%3ECould%20you%20please%20attach%20your%20sample%20file%3F%3C%2FLINGO-BODY%3E
hewbro4
Occasional Visitor

Hi Guru’s

 

I have set up a dashboard where you can enter a error number in A1 then select a date (month) from a drop down list in C1 and I’m wanting it to find the data for the date selected based on the error entered and return the value in C2.

 

Sheet 2 contains the list of errors in A2, the dates are in N2-Z2 and the data relating to the error and date are in N3-Z3

the dates in the drop down are identical as those in Sheet 2

 

im going crazy on how this can be achieved if at all

thank you in advance of 

 

1 Reply
Could you please attach your sample file?
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies