Link to home
Start Free TrialLog in
Avatar of eiyengars
eiyengars

asked on

Array Question in Google Spreadsheet

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
ASKER CERTIFIED SOLUTION
Avatar of Rick Hobbs
Rick Hobbs
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial