Thread: Find function
View Single Post
  #5   Report Post  
Jenniferpod Jenniferpod is offline
Junior Member
 
Posts: 8
Default

Quote:
Originally Posted by Jenniferpod View Post
It keeps saying I have a circular reference
Maybe if I just put it on one worksheet now until I understand how the function is working. So say I have four columns.... Column B and Column D have the same information in them but all jumbled. I want to find B1 within Column D. Then I want to bring the value of Column C next to the located D and bring it back to cell A1. I've tried to do a little chart to show you.

Purple Apple Blue Banana
Blue Banana Green Orange
Red Grape Purple Apple
Green Orange Red Grape