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

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

  1. orale anabole steroide online kaufen

    Excellent post. I was checking constantly this weblog and I’m impressed! Extremely helpful info specially the last section 🙂 I care for such information a lot. I was looking for this particular information for a very lengthy time. Thank you and best of luck.

  2. Acquistare Reductil in linea

    I discovered your weblog site on google and verify just a few of your early posts. Continue to maintain up the excellent operate. I simply additional up your RSS feed to my MSN News Reader. In search of ahead to studying extra from you afterward!…

  3. Online Kaufen

    Hey would you mind stating which blog platform you’re using? I’m going to start my own blog soon but I’m having a tough time selecting between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your layout seems different then most blogs and I’m looking for something unique. P.S My apologies for being off-topic but I had to ask!

  4. Ephedrine online kaufen

    Appreciating the time and effort you put into your blog and in depth information you provide. It’s nice to come across a blog every once in a while that isn’t the same out of date rehashed material. Fantastic read! I’ve saved your site and I’m including your RSS feeds to my Google account.

  5. check over here

    Great items from you, man. I’ve remember your stuff previous to and you are simply extremely excellent. I actually like what you have bought right here, really like what you are stating and the way in which through which you assert it. You are making it enjoyable and you still care for to keep it sensible. I can’t wait to learn much more from you. This is actually a great site.

  6. ig

    Excellent items from you, man. I’ve be mindful your stuff previous to and you’re just too fantastic.
    I really like what you’ve received here, certainly like what you’re saying and the way during which you are saying it.
    You’re making it enjoyable and you continue to care for to stay it wise.
    I can not wait to read far more from you. This is really a wonderful web site.

  7. gay.stagearea.it

    Heya i am for the first time here. I found this board
    and I find It truly helpful & it helped me out much.
    I’m hoping to give something again and help others such as you helped me.

  8. Buy Multivitamins

    I loved as much as you’ll obtain performed right here. The comic strip is tasteful, your authored material stylish. nonetheless, you command get got an shakiness over that you wish be delivering the following. ill without a doubt come more previously once more since precisely the same just about very incessantly inside of case you shield this increase.

  9. Buy Handicrafts Items Online in India

    You really make it seem so easy together with your presentation but I find this matter to be actually something that I believe I would by no means understand. It kind of feels too complicated and extremely broad for me. I’m taking a look forward to your next submit, I’ll attempt to get the grasp of it!

Comments are closed.