Find and Replace Arrays

**s2nguyen** · 10-24-2008, 03:10 PM

I will explain my problem using a simpler example.
I have a worksheet "A" that contains a bunch of different number in each cell in one column.
Worksheet "b" has a column "BA" of those number and beside that is a column "BB" that has texts.
so basically i want to find and replace all numbers for text, using that two columns from worksheet "B" as a decoder kind of thing. It would be very menial to use the find and replace functions because it can only look for one thing at a time, while i have to do 1000's.

Is there a function/Vb/formula that can do this for me?

**stanleydgromjr** · 10-24-2008, 04:45 PM

s2nguyen,

Please attach a sample of your workbook, with data in both sheets.

Have a great day,
Stan

**s2nguyen** · 10-24-2008, 05:04 PM

So column A has the data, in column b i want it to put the number correlating to that from column e and f. so for example it would find "1" (A31) in data cell and put "3056" in cell (B31) using the find and replace codes on the side,

**s2nguyen** · 10-27-2008, 09:30 AM

i tried =IF(A2=E2:E157, F2:F157, "Not found"), but doesn't work, maybe in conjunction with sum products?

**SSN651** · 10-28-2008, 08:43 PM

If I am understanding what you are asking for, try using the following formula in your column B of your sample file submitted above:

Please Login or Register  to view this content.

The lookup function looks at what is in the A column and then finds that value in column E, which needs to be in alphabetical/sequential order, and then gets the corresponding value for that row from column F.

John