Vlookup / @row usage

In the Vlookup formula, Category@row references 4 contiguous columns to obtain one value, I added a 5th column and Category@row does not recognize the 5th column. How do I redefine Category@row to use the 5th column ?

VLOOKUP(Category@row, {GL Account X Ref Range 4}, 2, false)

Thanks for your help!

Amy

Find more posts tagged with

Formulas

Accepted answers

MPC contact

Never mind!!! Found the issue and am good!

All comments

MPC contact

Never mind!!! Found the issue and am good!

DeAnna Masterson

@MPC contact What did you do to fix it? I'm having the same issue!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.