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")
Best Answer
-
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".
Answers
-
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".
-
Amazing! You saved me lots of time. Thank you!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 136 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 485 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
