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...
https://docs.google.com/spreadsheets/d/1UX48Qu_Y8B5WP7UKOp0d0z7LBcpFy37-/edit?usp=sharing&ouid=103744200735667771049&rtpof=true&sd=true
Thank you!
In C2 on the Main sheet:
=XLOOKUP(B2, CTN!$B$2:$B$27, CTN!$A$2:$A$27, "")
Fill down.
Alternatively, use
=XLOOKUP(B2:B4, CTN!B2:B27, CTN!A2:A27, "")
This will spill to C2:C4.