Will the index formula work for data that is listed by rows instead of columns. I am trying to capture information that is listed in two columns. I tried the index formula but something is not working. Can you help, tell me what it is that I am doing wrong. Thanks
Hi Melinda
In cell E5 of the BOARD worksheet you can try =INDEX(Cathy!$E$9:$E$72,MATCH(E$4,Cathy!$D$9:$D$72,0))
Hope this helps.
Sunny
Hi Sunny
Is it possible to still have the symbols on the chart?
Thanks
Hi Melinda
No idea what you wanted. Your current charts already have the symbols.
Are you intending to redraw the charts?
Maybe you can attach an example of what you wanted so that we can have a clearer picture.
Sunny
Sunny
You are right. Looks like the symbols got lost in the cut and paste. I can redo.
I really do appreciate "ALL" of your help.
Thanks
Sunny
Can you adjust my formula so that the chart is interactive. That is once I change the date on the board in column B7 the chart is updated as well.
Thanks
Give this a try.
