Share via

MS EXCEL How do fill a cell based on tab selection and row and column

Sean Harrison 20 Reputation points
2025-07-23T00:10:38.7166667+00:00

I need to be able to display a value ('CAL'!D9) by using matrix selection D5(='D3'!$B$3:$B$14) and D7 (='D3'!$B$3:$B$14) based on D3 which is a tab selected. Each tab is setup with same selection so JAN is identical to FEB but not the entries.

CALTAB

TAB

Microsoft 365 and Office | Excel | Other | Windows
Answer accepted by question author
  1. IlirU 1,356 Reputation points Volunteer Moderator
    2025-07-23T06:18:26.6766667+00:00

    Hi,

    This formula should work. Try it in cell D9 of tab (sheet) CAL.

    =INDEX(INDIRECT("'" & D3 & "'!C3:I8"), MATCH(D5, INDIRECT("'" & D3 & "'!B3:B8"), 0), MATCH(D7, INDIRECT("'" & D3 & "'!C2:I2"), 0))

    Hope this helps.

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. riny 20,525 Reputation points Volunteer Moderator
    2025-07-23T06:23:18.2233333+00:00

    Try this:

    =INDIRECT(D3 & "!" & D5) INDIRECT(D3 & "!" & D7)

    1 person found this answer helpful.
    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    1 deleted comment

    Comments have been turned off. Learn more

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.