Excel2010/Win7/Arrays/ Cell A1’s content is my array e.g. {“N”,0;”Y”,1} not recognized.

Excel2010/Win7/Arrays/ Cell A1’s content is my array e.g. {“N”,0;”Y”,1}  not recognized.

Request/Goal: I want to enter the values of an array manually in a cell and be able to use that cell content as my array reference.

e.g. My array values exist only in A1

#1) First excel cell location A1 with value: {“N”,0;”Y”,1}

#2) Then excel cell location A2 with value: “Y”

#3) Then excel cell location A3 with value/formula:

= VLOOKUP(A2,A1,2,0)

I’m expecting the value displayed in A3 results = 1

Note: I do not want the values in a regular table layout referencing multiple excel cells e.g. A1:B2 as I will have different values per row of different array sizes.

A1 = N

B1 = 0

A2 = Y

B2 = 1

By: SC

Leave a Reply

Your email address will not be published. Required fields are marked *