Solved

Array Question in Google Spreadsheet

Posted on 2014-10-28
1
242 Views
Last Modified: 2015-03-02
I am getting a REF Error when using the arrayformula as below in the google spreadsheet.


=arrayformula(IF(ISNUMBER(MATCH(D:D,Codes!$A:$A,0)),VLOOKUP(D:D,Codes!$A:$B,2,FALSE),""))


Is the syntax correct?


Thanks
0
Comment
Question by:eiyengars
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 22

Accepted Solution

by:
Rick Hobbs earned 500 total points
ID: 40412236
.Syntax is incorrect.  You have 4 left brackets and 5 right brackets,  Must be even.  It appears the last ) is incorrect.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Google Forms is a great platform to easily create polls, questionnaires and surveys. The service allows you to receive data in real-time and is a simple way to conduct large-scale surveys that can be distributed to multiple people.   The platform …
Learn about cloud computing and its benefits for small business owners.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Shows how to create a shortcut to site-search Experts Exchange using Google in the Chrome browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch the Search Engine Menu: In chrome, via you…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question