ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I create an array (https://www.excelbanter.com/excel-discussion-misc-queries/20865-how-do-i-create-array.html)

array_deficient

how do I create an array
 
I have a column of values that look like: 00000000007310F0000

all cells are 19 chars in length, and the 15th char is alpha. I need to map
the 15th alpha char to a numeric. the mapping is as follows:

ABCDEFGHI (column F)
123456789 (column G)

this is where I'm at:
=REPLACE(C3,15,1,(IF(MID(C3,15,1)=({F3:F12}),({G3: G11}),"")))

please help



All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com