Solved

Array Question in Google Spreadsheet

Posted on 2014-10-28
1
231 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Learn new improvements released by Google for Google Calendar. Noted in this article are simple tips and tricks that can make your everyday use of Google Calendar better.
Working with spreadsheets can be a daunting task, especially when having to deal with large amounts of data. All you see are rows and rows of numbers and soon your eyes begin to glaze over. Take advantage of the tools in Google Sheets to create prof…
This Micro Tutorial will demonstrate Google Calendar to monitor updates with top sites, such as Facebook, Google, Twitter, etc. with Marketing News. Each update of Google Calendar can be monitored, correlate dips and spikes in your website traffic, …
This Micro Tutorial demonstrates how to quickly find related content for YourTango's posts using MozBar Chrome extension.

939 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now