hi,
i'm stuck with search function and have tried various formulas throughout this forum and can't come up with a solution
my issue:
i have two sheets (sheets 1 and 2) i like to search the text in A1 to a column in sheet 2. if it can find the text in the column then return the results in column A of sheet 2.
example i'm searching 10Apple in column B of sheet 2. 10Apple text is located with the text of B1 so then it will return the results from A1. the results to return would be BIN10
sheet 1:
column A
A1. 10Apple
A2. 20orange
A3. 30banana
A4. 55plum
A5. 70grapes
sheet 2:
column A Column B
A1. BIN10 B1. 10AppleGrocery
A2. BIN50 B2. 10store99
A3. BIN20 B3. 20orangestore
A4. BIN20 B4. 20storeB
A5. BIN50 B5. 30bananastoreC
A6. BIN10 B6. 55plumstoreC
A7. BIN50 B7. 70grapesstoreE
A8. BIN20 B8. 80canada
A9. BIN10 B9. 90USA
i'm hoping someone can help me out with this as the search text is contained within the text.
Bookmarks