enter image description here

I am trying to figure out how to get the data from the data validation box in D13 and I 11 to return the intersecting data from the Formulas Sheet.

what I am doing is creating a sheet so that when the year is selected and the part(standard length or extended) under the parts notes is selected it will return the correct part number to cell N13.

  • Welcome. Please read how to and share a test sheet so as you can be easier helped. May 13 at 22:12
  • 1
    The screenshot doesn't help. What are the validation boxes in D13 and I11? What is the "Formulas Sheet"? While sharing a test sheet usually is very helpful all the relevant details should be included directly in the question body.
    – Rubén
    May 14 at 19:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.