Hi,
I've tried what feels like everything to extract some values in a column in one worksheet where the cells contain more than just the values i am looking for, from a column in a second worksheet- each column contains thousands of rows.
Here is an example of what i need to do:
Sheet one cells
1122334455
1234554321
Sheet two cells
1234-mat ref 1122334455
mat 4321 1234554321
I want to be able to search for the values in sheet one, in sheet two and either extract the values it finds, or return a Yes (or anything).
Is this possible?
Thanks in advance
I've tried what feels like everything to extract some values in a column in one worksheet where the cells contain more than just the values i am looking for, from a column in a second worksheet- each column contains thousands of rows.
Here is an example of what i need to do:
Sheet one cells
1122334455
1234554321
Sheet two cells
1234-mat ref 1122334455
mat 4321 1234554321
I want to be able to search for the values in sheet one, in sheet two and either extract the values it finds, or return a Yes (or anything).
Is this possible?
Thanks in advance