VLOOKUP or IF?

Hello, I am not sure if I should be using VLOOKUP or an IF/THEN statement or a combination of the two. Any help is greatly appreciated. Thank you.

Problem Statement: I want the PWS link to auto populate based on the Areas of Support selection.

Both columns are dropdowns.

Current attempt gives me a circular reference.

=IF([Areas of Support]@row = "Acquisition Planning", [PWS Link]@row = "3.2.1 Acquisition Planning")

Find more posts tagged with

Accepted answers

Paul Newcome

You do not need to reference [PWS Link]@row. You are putting the formula in that cell, so all you need the IF statement to output is "3.2.1 Acquisition Planning".

All comments

Paul Newcome

You do not need to reference [PWS Link]@row. You are putting the formula in that cell, so all you need the IF statement to output is "3.2.1 Acquisition Planning".

EB1209

https://community.smartsheet.com/discussion/comment/466022#Comment_466022

Amazing! You saved me lots of time. Thank you!

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.