Forum Discussion
Need Formula to Pull Specific Data
I am attempting to pull data from one sheet into another if certain key words are met. The data is static but I just need it to read data entered in one column and pull the related CTN. I've attached...
For Excel older versions, you may use INDEX/MATCH().
=INDEX(CTN!A:A,MATCH(B2,CTN!B:B,0))