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
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies