• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cell referencing with tabe

MBS

Member
Hi all,
I have data in table format in 3 sheets. i want to display this as per selection in cell A1 in fourth sheet. please help to know more about how to do cell referencing in table format as did when data is in range format. Sheet is attached.
thanks.
 

Attachments

  • Cell referancing with Table.xlsx
    21.3 KB · Views: 3
Do you mean like this?
Code:
[A3]=INDEX(F_21[Jan],MATCH($B3,F_21[[Particular]:[Particular]],0))

or, if you want to use the drop down selection (change your list to F_20, F_21, F_22.)
Code:
=INDEX(INDIRECT($A$1&"["&C$2&"]"),MATCH($B3,INDIRECT($A$1&"[[Particular]:[Particular]]"),0))
 

Attachments

  • Cell referancing with Table.xlsx
    19.8 KB · Views: 2
Last edited:
  • Like
Reactions: MBS
Do you mean like this?
Code:
[A3]=INDEX(F_21[Jan],MATCH($B3,F_21[[Particular]:[Particular]],0))

or, if you want to use the drop down selection (change your list to F_20, F_21, F_22.)
Code:
=INDEX(INDIRECT($A$1&"["&C$2&"]"),MATCH($B3,INDIRECT($A$1&"[[Particular]:[Particular]]"),0))

............Many Thanks GraH - Guido
 
Back
Top