VLOOKUP or IF?

EB1209

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")

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".

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. 👍️