May 20 2019 07:06 AM
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
May 20 2019 07:20 AM