# Formula needed to search data then copy into different cell if found

1. ## Formula needed to search data then copy into different cell if found

Hi I am new to this forum and am hoping some one can help please.

I have alot of data that I need to find certain references within, all this reference are typically around 15 characters long but all start with "0062000" and they contain both numerical and alphabetical characters. I need a formula that will search the whole spreadsheet and locate the references then once it has copy the reference into a new cell/column.

Is this possible, can anyone help please?

Thanks
Liz

2. ## Re: Formula needed to search data then copy into different cell if found

Cells can't copy to other cells, you need VBA for that, so that's one solution.
However, you can give a cell a value dependant on the result of another cell.
e.g.
A1="0062000ABCDE"
A2="0063000ABCDE"

then in B1
=IF(LEFT(A1,7)="0062000",A1,"")
in B2
=IF(LEFT(A2,7)="0062000",A2,"")

B1 would be "0062000ABCDE"
but B2 would be blank (since the first 7 characters of A2 are "0063000"

3. ## Re: Formula needed to search data then copy into different cell if found

Hi Special-K,

Thanks for your response. this is great and much closer than I was previously, however I need it to just pick up the actual reference it has found and copy that into the separate cell and not everything contained within the cell, do you know if that is possible at all please?

Thanks,
Liz

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1