title: Excel formula to pull data and numbers from one row
body: <p>I have an excel sheet with names of items in columns B7:B100. I want to pull that name to another sheet if column G has an x in it. Then on the same sheet in another column I want to pull a dollar figure in the same row but from column AN. I have tried several functions I keep coming up with #value.</p>