Power query excel 2013 - feedback loop?

[mistersink]

Hi
For simplicity say i have three columns: A=number 1-10 for 10 rows, B=category, C=a text comment. I want to be able use power query to filter by category column from Sheet1 and put it into Sheet2 (easy enough). The complicated part is I want to enter comments in column C on Sheet2 (that is querying Sheet1). Then I use index match in the comment column of Sheet1 to pull the comment entered in Sheet2. The problem is everything looks fine until I hit the refresh button on Sheet2 query. I was hoping that it would query what is currently on Sheet1 from the index match, but it ends up clearing the comment from Sheet2.
Any ideas?
thanks so much!

 

[sandy666]

maybe try Self Referencing Tables in Power Query - Excelerator BI

 

[cmckayneal]

Try this one. It sounds like it may work for your situation.