0

"Dashboard" enter image description here

Weekly Calls: enter image description here

Formula: enter image description here

I am trying to create a dashboard that allows me to pick a week and a company name and then it would pull the appropriate "jobs booked" number. I am using an Index Match formula that I have used for other things and it doesnt seem to be working.

I also would like to take this one step further and eventually narrow it down to specific business units that are in column B (Weekly Calls) and Row 4 (Sheet1).

Formula attached above.

Improve this question
2
  • Sounds like you need a helper column where you combine the week and company name together and match by that. Commented Oct 24, 2023 at 16:08
  • @solarmike can you expand on that? Sorry not completely sure what you mean by that. Commented Oct 24, 2023 at 16:49
Related questions
0
Multiple criteria for index match
0
Index and match with multiple criteria and multiple range
446
Is there an R function for finding the index of an element in a vector?
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.