Using a VLOOKUP and IF statement to return different values based on two different columns
Hi,
I'm so sorry if this kind of question has been asked in the community forum but I've been trying to comb the questions but haven't had any true luck yet.
Currently I used a VLOOKUP function to populate a personnel contact column based on a particular project column. That part is working correctly. However, recently I needed to add in another criteria in addition to the VLOOKUP function below.
Here is what I am trying to do.
In the Contact column, if a particular study type (this is one of the columns) is ="PK" or "PKPD", then I want the contact column to populate the column using the VLOOKUP function that I already created.
However, if a particular study type is ="Formulation Check" or "Stability Assays", I want the column to bypass the VLOOKUP and just return a blank cell.
AT this point I have no idea even where to start because of the two conditions.
Is this something that is even possible? Thank you so much for any insight on this!!
Savita Ubhayakar
Best Answers
-
This should be possible with IF & OR functioning. If the Formulation Check/Stability Assays are the only other options then you can use this:
=IF(OR([Study type]@row = "PKPD", [Study type]@row = "PK"), <insert your VLOOKUP formula here>, "")
If there are more options, just use an additional IF & OR statement for the 2 others and so on.
Hope this helps, but if you've any questions etc. then just ask!
-
Hi @Nick Korna
THANK YOU SO MUCH!! IT WORKED!! I really appreciate your help with this!! So fast! Thanks again! You all are miracle workers!!! You saved me so much time!
Thanks again!!
Savita Ubhayakar
Answers
-
This should be possible with IF & OR functioning. If the Formulation Check/Stability Assays are the only other options then you can use this:
=IF(OR([Study type]@row = "PKPD", [Study type]@row = "PK"), <insert your VLOOKUP formula here>, "")
If there are more options, just use an additional IF & OR statement for the 2 others and so on.
Hope this helps, but if you've any questions etc. then just ask!
-
Hi @Nick Korna
THANK YOU SO MUCH!! IT WORKED!! I really appreciate your help with this!! So fast! Thanks again! You all are miracle workers!!! You saved me so much time!
Thanks again!!
Savita Ubhayakar
-
Happy to have helped! 😊
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!