Hi,
I am trying to copy and paste column data from Sheet1 into Sheet2 if a text is found in Sheet 1. I would like to grab the Content Code column (Column C) from Sheet1 if the Content System column (Column A) has a the word Oranges. Then I would like to grab the respective Content Cost. The data in Sheet 1 is dynamic and a table. Every month there could more or less rows added or removed. So I would like the formula to be dynamic as well.
I have tried Index Match and Vlook Up and nothing as worked! My formula is "INDEX(Sheet1!C:C,MATCH("Oranges",Sheet1!A:A0))"
Could someone advise on this problem? Is there another formula for this. I have attached a sample.
Thanks alot for your help!
Bookmarks